AnsweredAssumed Answered

Finding an "exact value" in a field

Question asked by Polarpro on Apr 19, 2010
Latest reply on Apr 19, 2010 by Polarpro

Title

Finding an "exact value" in a field

Post

Hey,

 

I've got a field that can contain several values. The vales are separated by carriage returns.

 

In record #1 the field contains

002 A¶

002A¶

002

 

In record #2 the field contains

002 A¶

002A

 

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¶".

 

Any ideas?

Thanks a lot  :-)  Mike

Outcomes