Using a string in an SQL query

[Lynus]

Hi Folks. I am searching threw a database based upon criteria that the user enters. So the user would enter "test" for the search criteria. I set up a string and am calling it searchstringtext. Now my question is are you allowed to use strings in your sql statements. IF so how do you achieve it. Below is a samble of my code.

Set newrec = New ADODB.Recordset
newrec = "SELECT * FROM bugs WHERE dbbugdescription LIKE ('searchstringtext')"

Any help would be greatly appreciated.
Thanks

 

[andylec]

"SELECT * FROM bugs WHERE dbbugdescription LIKE ('" & searchstringtext & "')"

 

[SemperFiDownUnda]

don't forget the * or % depending on what database you are connecting to. Otherwise if you want an exact match don't use LIKE

ie
"SELECT * FROM bugs WHERE dbbugdescription LIKE ('%" & searchstringtext & "'%)"
for finding the value in searchstringtext anywhere in dbbugdescription
or
"SELECT * FROM bugs WHERE dbbugdescription LIKE ('" & searchstringtext & "%')"
for only records that dbbugdescription starts with the value in searchstringtext