SQL query using "Like" is giving me some problems

[pparadis]

I have an sql query used to search for projects that match a users input string. The query works when I take it out of the code and try it in Access, but it wont work when trying to run it from my page. Anybody know why it would do this? Thanks. Here is the SQL:
strSQL = "Select * From Projects Where
ProjTitle Like '*"&Request.QueryString("ProjectTitle&quot&"*'
AND ProjDescription Like '*"&Request.QueryString
("Description&quot&"*' AND ProjStatus = '"&Request.QueryString
("status&quot&"'"

 

[Cheech]

Try

strSQL = "Select * From Projects Where ProjTitle Like " & Request.QueryString("ProjectTitle&quot & " AND ProjDescription Like " & Request.QueryString("Description&quot & " AND ProjStatus = " & Request.QueryString("status&quot Live long and make your kids suffer..

 

[lobstah]

the wildcard when using LIKE is the percent sign (%), not the asterisk (*). try:

strSQL = "Select * From Projects Where ProjTitle Like '%" & Request.QueryString("ProjectTitle&quot & "%' AND ProjDescription Like '%" & Request.QueryString("Description&quot & "%' AND ProjStatus = '" & Request.QueryString("status&quot & "'"

 

[pparadis]

Thanks to both of you. Helped me open my eyes.