Find does not find all records

[CamMac2]

I'm performing a find in a calculation field that combines 3 different fields. If any info is missing from any field, the field will display the word ERROR.

The problem I've encountered is, when I try to find the word ERROR in the field, it will only return the records where ERROR is the last word in the field.

Example:

(record 1 field): 4/C-1/12-ERROR

(record 2 field): 4/C-ERROR-002

will only find the record where the field contained "4/C-1/12-ERROR" and ignore the other record.

I have made a new text field that uses Set Field to copy the values from the calculation field, and did the find in that field, but same results.

I've tried *ERROR and "ERROR" and always get the same results -

I hope I've given enough info, but I am stumped...

Thanks

[-Queue-]

You were close with *ERROR. Try *error*. Since the field in the second record has 'error' in the middle, you need wild cards (*) at the beginning and end of your search string.

[CamMac2]

Yeeha!

That was it!

Thank you.