Hello Thanks for the support

hey

I have page where is want to search my db, this is the statement i have now
SELECT *
FROM ServiceInfo
WHERE (Keywords LIKE '%MMColParam1%' AND ActualLocation LIKE '%MMColParam2%')
ORDER BY Program ASC

MMColParam2 XXXX Request("Search_ActualLocation")
MMColParam1 XXXX Request("Search_Keyword")

I can search the two fields together but i also wanted to search either by keyword or by location. i needs to search by any field or both fields.

Any Sugggestions

Then keep adding to the WHERE clause...

... WHERE (field1 LIKE value1 AND field1 LIKE value2) OR (field3 LIKE value3 AND field4 LIKE value4)

Im not really sure what u are saying if i have two box's. One is a txtfield and the other is a list box. I want to be able to search either the txtbox or the list box or both. So i should have 3 where statements following one another and do is use the same variables for the sql string???

Not too good at sql sorry.

Newfiebullet

You want to search the text box or list box? Or you want to use the values in the text box and list box to search the database?

If it's the later, you would have two statements in your WHERE clause:

... WHERE field1 = textboxValue OR field1 = listboxValue

Maybe this will give you some ideas:

ASP Design Tips - Search For an Expression on Multiple Fields
http://www.bullschmidt.com/devtip-se...iplefields.asp