I've seen many posts on how to insert data containing apostrophe's into a database but not on how to retrieve data with apostrophe's. Here's my situation.<BR><BR>I have a class title field. Some of the values contain apostrophes. On the first page the user goes to, there is a drop-down list containing all the class titles. The user selects a class title and clicks a button to see the list of individuals who have taken that class. Of course, if there is an apostrophe in the class title, my SELECT statement errors out. Here is the code I'm trying to use to get the names:<BR><BR>TTitle=request.form("TTitle")<BR><BR >sql = "SELECT * FROM Classes WHERE Title = '" & TTitle & "' ORDER BY MgrName,EmpName,EDate"<BR><BR>Any ideas on how I can make this SELECT statement work? If this can't work, then I may have to recode the site so that I lookup the class ID instead of the title (this is how I would have done it in the first place, that's the fun you have when you takeover some one else's web site).<BR><BR>Thanks for any help you can give. I apologize if this question has been answered else where.