I am trying to use LIKE in a web page and the syntax looks ok but I never get the correct results. Here is what the sql statement looks like:

Select * from Drawings where ProjectID =1 and Title LIKE "*cover*"

Can anyone give me any pointers, the database connection is fine other sql statements generated by the page works fine just not this one, well it does not give an erros just an empty recordset.
...