Search string to Query multiple columns in a table

[Jeremy]

Ok I'm really new to working with SQL and FP 2003. But I have created a table
and have a submission page actively posting data to my database but now I would like to create a search that can find data from any of the columns in my table.

example:

WorkID Name Job

231 John Electrical

I'd like to put just one text box in which a user could type either John/231/or electrical and have it pull up the record from the database. But I am stumped as to how to setup the custom search string. Is this possible? If so could someone give me some suggestions? Let me know. Thanks

 

[Kevin Spencer]

some suggestions? Let me know. Thanks

I would suggest you post your question only once. Double-posting tends to
make people less cooperative (bad netiquette). See my answer to your first
post.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

Ok I'm really new to working with SQL and FP 2003. But I have created a table
and have a submission page actively posting data to my database but now I

would like to create a search that can find data from any of the columns in
my table.

example:

WorkID Name Job

231 John Electrical

I'd like to put just one text box in which a user could type either

John/231/or electrical and have it pull up the record from the database. But
I am stumped as to how to setup the custom search string. Is this possible?
If so could someone give me some suggestions? Let me know. Thanks