How to use a variable in an SQL "LIKE" statement? 1

[guineamation]

I would like to create a full text search on a DB column using the SELECT...LIKE type statement. How do I call the variable "form" for ex. into this statement.

 

[Genimuse]

I'll change your variable name for the example to "last," as "form" is a very bad name for a variable.

Here's what the SQL would look like:

SELECT * FROM MyTable WHERE LastName LIKE '%evans%'

So, for example, if you were assembling a sql string to add to your .open command, your asp might look like this:

strSQL = "SELECT * FROM MyTable WHERE LastName LIKE '%" & last & "'%"