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

Escaping LIKE wild-cards with MS-Jet (Access)

P: n/a

I need to search for database text with underlines in it. However,
underlines are interpreted as wild-cards in LIKE clause text . I need
to know how to escape the underlines so as to be able to search them.
Some DB's use an "Escape" keyword and others use a back-slash to escape
wild-cards. However, Jet does not seem to support either of these.

Note that I am accessing Access files via ODBC and ADO (or is it DAO?)
and not through Access directly.

Thanks in advance, -T-

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Like "*[_]*"

Nov 13 '05 #2

P: n/a
Thanks! Did the trick! You get an "Avoid Offshoring For Free" card.

Nov 13 '05 #3

P: n/a
LOL!

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.