Entry

How can I set up the SQL statement to allow apostrophes in the WHERE clause, without causing a syntax error?

May 24th, 2000 07:45
unknown unknown, Serdar Kilic

You need to "escape" it

e.g.
strQuery = "Barron's"
strQuery = Replace(strQuery,"'","''")

strSQL = "SELECT myField FROM myTable WHERE myField = '" & strQuery & 
"'"