Hello Programmer Gurus!
I am trying to query my databsse of 10 ten fields for a search page.
When I use:
Model1 like '" & Search & "%' AND Model2 like '" & Search & "%'AND AND Model2 like '" & Search & "%'

I only get results from the first like statement. I know I have matching criteria in the other fields. any ideas??

Actually my error from above! I get NO results! but if I remove the last "Like" statement, The first one works fine!????

Ahhhhhhhhhhhh!

Sorry!
Model1 like '" & Search & "%' AND Model2 like '" & Search & "%'AND Model2 like '" & Search & "%'

Above had an extra "and".... Still doesnt work though.

Select * FROM tablename WHERE (columnname1 like ('%ValueA%')) OR (columnname2 not like ('%ValueB%')) limit 10;

Good luck!