[RESOLVED] Search multiple words from textbox in database

[kareninstructor]

If you wrote a select statement within MS-Access the code might look like this (replace the single characters with words and alter the like operator that fits your needs)

SELECT Products.[ProductID], Products.[ProductName]
FROM Products
WHERE (((Products.[ProductName]) Like "C*")) 
   OR (((Products.[ProductName]) Like "U*"));

You would then transform to

SELECT ProductName
FROM Products
WHERE ProductName Like "C*" OR ProductName Like "U*"

So with this pattern you need to determine how many words there are in the TextBox and alter the SQL as needed. Another option is to have several TextBox controls, check each one to see if they have content and if so build your select statement around them. Adding params in ASP is something I do not have code for as I do not code ASP. I would think there are alternate methods to do your params.