By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,829 Members | 673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,829 IT Pros & Developers. It's quick & easy.

Query Problem using wildcards

P: n/a
I have a field called 'Details' that is of type 'Memo' I have a query
that says:
"SELECT * FROM TableName WHERE Details LIKE '*Ceiling Tile*';"
I know that there are memos in the Details field that has the 'Ceiling
Tile' in it, but when I run the query I get a pop up window that says,
"Invalid Argument" What can be done?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I think you need to change your query to look like this

"SELECT * FROM TableName WHERE Details LIKE ""*Ceiling Tile*"";"

Note the 2 double quotes around *Ceiling Tile*

"Joseph VanWagoner" <jo*********@yahoo.com> wrote in message
news:aa**************************@posting.google.c om...
I have a field called 'Details' that is of type 'Memo' I have a query
that says:
"SELECT * FROM TableName WHERE Details LIKE '*Ceiling Tile*';"
I know that there are memos in the Details field that has the 'Ceiling
Tile' in it, but when I run the query I get a pop up window that says,
"Invalid Argument" What can be done?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.