i am trying to do a query where the user enters the query type eg title, author, ect. and the user enters the query string eg "fun with asp"
ok my problem is how do you do a Like query where the all title for instance that have "fun with asp" as part of thier title are returned
heres what i have
strSQL = "SELECT * FROM Publications WHERE '"& request("type&#34&"' Like
'*"& request("string&#34&"*' "

type is the type of query like if its a title or author
string is the user entered stearch string
both type and string are posted from a previous page.

the strSQL line doesnt give me an error but it also doesnt return anything