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

Searching in Access

P: n/a
I have a search feature on a form that takes input in a series of
fields. The VB code builds an SQL statement based on the entries in
the various fields. Right now you have to enter the information
exactly as it is listed in the database. I would like to have the
ability to search for partials using wildcards. How do I add this
ability?
Sep 26 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sep 25, 8:09*pm, iwasinnihon <iwasinni...@gmail.comwrote:
I have a search feature on a form that takes input in a series of
fields. *The VB code builds an SQL statement based on the entries in
the various fields. *Right now you have to enter the information
exactly as it is listed in the database. *I would like to have the
ability to search for partials using wildcards. *How do I add this
ability?
when you build you statement use the * character

select * from tblCity where city like '*wash*'
Sep 26 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.