Compare Difference btwn 2 Text fields

[crystalfun]

I am testing a data conversion using reports from legacy and the new system. I want to see if the fields imported properly.

Field 1 is a text field and looks like: 12345-123
Field 2 is a text field and looks like: 12345-123

I want to compare Field 1 to Field 2 to look for a difference. How can I do this if both fields are text?

 

[lupins46]

I feel there is more to your question than you are saying.
In a query just do:
Result:field1=field2

This will produce -1 for true and 0 for false.

 

[PHV]

You may use any comparison operator with text fields plus the Like operator.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244