I have an ASP page in which I need to query an Access database for names. Below, I have the current query I'm using. Unfortunately, it doesn't work for names like O'Malley and D'Amour because I'm using the single-quote to separate my string values in the SQL string.
It's been a while since I've coded ASP and I've forgotten how to escape the ' character so that it will be able to go through the DB.

strSql = "Select * From Students Where FirstName='"&fName&"' AND LastName='"&lName&"'"

Can someone please help?

Chris

Hi Chris,

Just replace any apostrophes (') with two apostrophes ('').

HTH,

Chris

OK, I got it. Thank you.

hi the solution to ur query is as follows

strSql = "Select * From Students Where FirstName='"&Replace(fName,"'","''")&"' AND LastName='"&replace(lName,"'","''")&"'"

to be professional just write a function like this and pass your variables to it;

Public Function ReplaceString(ByVal strString As String) As String
        Return strString.Replace("'", "''")
End Function

And use it like this

strSql = "Select * From Students Where FirstName='" & ReplaceString(fName) &"' AND LastName= '" & ReplaceString(lName)& "'"