Problems using like for a title search

[Bill]

I'm trying to pull up all the titles in our database that have a word
like the one submitted from our search form.

The string is like this:


title=request.form("title")

sql=" SELECT * FROM books where title like '"&%title%&"' ORDER BY
title "

If I run a search straight in sql server using the %title% with the
percent signs before and after the variable name title, it will
dutiflly return all the titles that contain that word. However, when I
run the above string in asp, I get an error. Note I have '"&%title%&"'
That's quite a lot wrapped around it. I've tried a few variations of
this, but keep getting error messages. How do I do an approximate
search this way?

Thanks,

Bill

 

[Manohar Kamath [MVP]]

Try this:

sql=" SELECT * FROM books where title like '%"& title "%' ORDER BY title "

 

[dlbjr]

strSQL = " SELECT * FROM books WHERE title LIKE %" & title & "% ORDER BY
title "

dlbjr

Unambit from meager knowledge of inane others,
engender uncharted sagacity.

 

[Bill]

Thanks! That worked great.

Bill