Using Microsoft Query to Extract Data

[Jim Wallace]

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.

 

[Phobos]

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