Finding an "exact value" in a field
I've got a field that can contain several values. The vales are separated by carriage returns.
In record #1 the field contains
In record #2 the field contains
My problem is that when searching for 002 both records match (as in record #2 002 is a part of 002 A). So, my question is: What can I do to search only for those records that contain exactly the value 002? =002 doesn't help and ==002 doesn't help either, as the latter searches only for records where the whole field content matches. "=002" didn't work either.
I wonder if the only way to get done what I need is to add a ¶ at the end of the last value in a field and search for "002¶".
Thanks a lot :-) Mike