I want to take text from a user and have it search for some or part of what they enter with colums in 2 or more tables?

Can it be done? If yes can someone point me in the right direction?

Specific post can be more helpful.

I think I need to take the text that someone put in a web form and then break it up so I can search for any one of those words in a SQL statment. I need help in how to get sql to go though that and put them all together in one query? Any idea?

This is what I have now and I know it is not even close:

SELECT distinct list_company, List_state, list_address_1, LIST_CITY, LIST_PHONE_1, LIST_EMAIL
FROM master_list, category where master_list.list_company like '%#advfind#%' or master_list.List_state like '%#advfind#%' or master_list.List_address_1 like '%#advfind#%' order by List_Company

What is your database? MSSQL or MS Access?

In ASP code, you can use Split(expression, delimiter) to seperate the string which user types in. When you get the keywords (in array), you need a For loop and then add all keywords into WHERE clause.

SQL Server 2000

You know coldsufion?

Why did you use "#" in your WHERE clause? Okay, I know why because of coldsufion. I know a little.

Because the person askig for this search funtion is using Coldfusion

After you get keywords from the string that use enters in the form, you can do a loop and then add the keywords in WHERE clause.