Searching Database

[Lloyd Stevens]

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

[Keith Wilby]

Re: Searching Database

lloyd_stevens20 01@yahoo.com (Lloyd Stevens) wrote:
[color=blue]
> 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.[/color]

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.