View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 216
Default Wildcard character with Select Statement

What is wrong with my snytax? I've created a macro to
retrieve info from an Access table. Here is the query
passed to the connection object:

strSQL = "SELECT value FROM " & strTable & " WHERE
PageRef LIKE '??10'"