Searching A String Within a String

[Leviathan via AccessMonster.com]

I'm trying to determine if a unique string of data from one field exists in
another field. For example, the first column might have the values 12345, and
the second column might have the values ABC12345 or 12345ABC or AB12345C, etc.
The starting point of the matching string is random. How would I compare the
two?

Thanks!

 

[Leviathan via AccessMonster.com]

Used the search.

InStr function seems to be what I'm looking for.

Out of curiousity, are there any other functions that work?

 

[John Spencer]

WHERE FieldA LIKE "*" & FieldB & "*"

Would return all records where fieldB was contained in FieldA

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..