I need some way of converting a boolean-style request to an SQL statement. Here is an example (don't assume this will have anything to do with cars):
User inputs:
sunroof and four door not red
SQL statement created:
Select * From TblItems Where Description Like '%sunroof%' And Where Description Like '%four door%' And Where Description Not Like '%red%'
I'm well-versed in VB.
However, I do NOT know ASP, nor do I know SQL. This was just dumped in my lap.
Ideas, anyone?




Reply With Quote