insert quotes and apostrophes

[jazzmaster111]

Hi, how I can insert a string which contains quotes and apostrophes in an insert query???

Thanks!!

 

[PHV]

The usual way (for "O'Neil"):
INSERT INTO myTable (myColumn) VALUES ('O''Neil')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JarlH]

Another solution is to use a "unicode-string-literal",
e.g. U&'O\0027Neil', where 0027 is the hexadecimal code for "'". (But, of course, PHV's way is much easier...)