Like operator help......

[andrest]

How can I query a table using a variable instead of a string?

SELECT AuthorLastName FROM BookList
WHERE BookTitle LIKE '*Cook Book*'

It doesn't work like the following.

SELECT AuthorLastName FROM BookList
WHERE BookTitle LIKE '*VARIABLE*'

andrest

 

[CajunCenturion]

You might try the following for a string

"SELECT AuthorLastName FROM BookList
WHERE BookTitle LIKE '" & TheVarName & "%'"

Leave out the single quotes for a number.
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein