Are you trying to find the position of the search string within another
string or just checking to see if the string exists?

If the latter, use "WHERE [Field] Like '%searchstring%'

P


"Jim Wallace" wrote in message
...
I am using Microsoft Query to take data from an ODBC
connection to populate a spread sheet. I need to look
through a text field for the selection criteria to find a
certain string. In Access there is the INSTR() function, in
Foxpro it is the AT() function and in SQL Server it is
CharIndex() Function, Is there a matching function in
Microsoft Query that will find a string in a String?
Thanks.