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?