How to search for a string in database

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

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...

Thank you very much