String with single quote (Quotation mark) 1

[kayek]

How do you handle a SQL command that uses a string that has a single quote in it?

For Example:

OldName = "Jone's Company"
NewName = "Jone's House"

SQL = "UPDATE table SET Name = '" & NewName & '" _
"WHERE Name = '" & OldName & ';"

docmd.runsql SQL

I get a syntax error.

 

[jrbarnett]

Hi

Use two apostrophes together, eg:

OldName = "Jone''s Company"

For a double quote, use the same technique - put two together. eg

strString = "Fred said ""Hello"""

John

 

[kayek]

That worked. Thanks!