Using Microsoft Query to Extract Data

  • Thread starter Thread starter Jim Wallace
  • Start date Start date
J

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.
 
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
 
Back
Top