Using Microsoft Query to Extract Data
 

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.

Using Microsoft Query to Extract Data
 

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.