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?