SQL and Apostrophes

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?

Quote:

---

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

Code:

---

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

---