View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Wallace Jim Wallace is offline
external usenet poster
 
Posts: 1
Default 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.