How to search for a string in database

[thinh]

How can i search for a string in database and then display everything in the recordsets that contained that string using ASP...

[Clunietp]

Your SQL statement will look something like this:

"Select * from MyTable where MyField LIKE '%" & MyString & "%'"

I'm assuming you already know how to connect to your DB from ASP...

[thinh]

Thank you very much