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

Searching Database

P: n/a
Is there a way to peform a query search on a database where you type
in a word to be searched across multiple fields?

a bit like a search engine if you like.

for example if searching a stock database typing in the word shoes
would bring up all products with the string shoes in the product name,
but also in description and so on.

regards Lloyd
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ll***************@yahoo.com (Lloyd Stevens) wrote:
Is there a way to peform a query search on a database where you type
in a word to be searched across multiple fields?

a bit like a search engine if you like.

for example if searching a stock database typing in the word shoes
would bring up all products with the string shoes in the product name,
but also in description and so on.


Well you could create a query with something like Like *[Enter keyword]* in
the criteria of all the fields you want to search (using the "or" lines),
otherwise I think you'd have to do it in code.

Regards,
Keith.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.