SQL and Apostrophes

[DaveR]

Hello,

How do you deal with apostrophes when you are dealinf with a SQL statement?


i.e. , using update statement with one of the criteria containing an apostrophe - it gives an error

i.e. update name set code = 1 where name = ' " & name1 & " '

and name1= Smith's


Any ideas?

[kleinma]

Originally posted by DaveR
Hello,

How do you deal with apostrophes when you are dealinf with a SQL statement?


i.e. , using update statement with one of the criteria containing an apostrophe - it gives an error

i.e. update name set code = 1 where name = ' " & name1 & " '

and name1= Smith's


Any ideas?

use the replace function

"update name set code = 1 where name =  '" & replace(name1,"'","''") & "'"