RE: Adding a ' in a sql statement

"INSERT INTO testtable VALUES ('Rich''s test');" -----Original Message----- From: Richard Krenek [mailto:rkrenek@ihs.com] Sent: Thursday, July 06, 2000 9:37 AM To: informix-list@iiug.org Subject: Adding a ' in a sql statment I am trying to add the line "Rich's test" in a varchar field but I cannot add the '. How would I do this? I've tried "INSERT INTO testtable VALUES ('Rich\\'s test');" but that does not work. Ive even tried \\\\' and \\\\\\'. Any ideas? thanks, Richard Krenek ------------------------------------------------------------------------------------------------------------ This e-mail is sent by a law firm and may contain information that is privileged or confidential. If you are not the intended recipient, please delete the e-mail and any attachments and notify us immediately.