SQL/ASP error

[DKCK]

Some of my fields are names with ' in them (ex: Kelly's Pub, Tom's Place). When I try to do do a query for these names in ASP, the ' in the string causes an error.

Quick example:
var = "Kelly's Pub"
rsRecordSet.Open "SELECT * FROM Ads WHERE Rest = ' " & var & " ';"

What I end up getting is three ' which doesn't work. Can I replace the two outside ' with another symbol? What is the best way to work around my problem?

[Sundance Kid]

Use the replace statement. When you save it to the database. Then you can use SQL to retrieve it.

 strings = Replace(Exp,"'","''") 

THat is Replace(Exp,','') Double single quoates " ' ".

[LucGuldentops]

You do not have to modify your data to solve the problem, just modify your sql statement.

Replace the single quotes in the sql string by 2 double quotes like this:

rsRecordSet.Open "SELECT * FROM Ads WHERE Rest = "" " & var & " "";"

Your DB will do the translation and wont give any errors on the use of quotes in your variables.

Greetz, Luc

[DKCK]

Thanks for the answers. I will try them out.