Wildcard character with Select Statement

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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'"
 
Your SQL statement works for me as printed (I created a database to test
it). What is the exact error message you are getting?

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

Shockley
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find/Replace MSWord wildcard characters from within Excel 6
Top n query using Allen Browne's "ConcatRelated" 3
Using a WILDCARD (%) in the SELECT clause 2
removing trailing returns 11
Wildcard question 1
SQL wildcard question 3
Problem with Search Button and SQL Statement 5
Help - onclick sub never runs 4

Back
Top