Hi,
I have one form in asp ,
User type some word in it .
I want search in database for them .
my database have one table and one field.
Table name : Catalog
Field name : Select
For example user type this :
“combine Search”+algorithm new
it means :
“Combine Search” AND “Algorithm” OR “new”
in sql means :
from [Catalog] where
[Catalog][Select] like “%Combine Search%” AND
[Catalog][Select] like “%Algorithm%” OR
[Catalog][Select] like “%new%”
I want create this sql .
How can I do?
Thanks ,