B bowldog Registered User. Local time Today, 20:27 Joined Mar 8, 2002 Messages 22 Nov 10, 2004 #1 I have a field with 3 digit numbers. e.g. Field A 123 429 231 745 312 I am trying to use the "like" operator to catch 123 in any order, so my result would be 123 231 312 Thanks in advance for any help/suggestions.
I have a field with 3 digit numbers. e.g. Field A 123 429 231 745 312 I am trying to use the "like" operator to catch 123 in any order, so my result would be 123 231 312 Thanks in advance for any help/suggestions.
Brianwarnock Retired Local time Today, 20:27 Joined Jun 2, 2003 Messages 12,667 Nov 10, 2004 #2 Like "*1*" And Like "*2*" And Like "*3*" Brian
B bowldog Registered User. Local time Today, 20:27 Joined Mar 8, 2002 Messages 22 Nov 10, 2004 #3 Thanks Thanks a bunch.
