Inserting strings containing apostrophes

I'm using 8.1.7 Enterprise.

The following insert statement fails because of the apostrophe after the word ticket:

        INSERT INTO TABLE ( VARCHAR2 column ) VALUES ('ticket's required');

I can get around it by adding an extra apostrophe:

        INSERT INTO TABLE ( VARCHAR2 column ) VALUES ('ticket''s required');

and the insert works. But that's not a workable solution for what I'm doing.

Anybody have other ideas, like surrounding the string with escape characters, quotes, etc. I've tried several ways and can't get anything to work.

Thanks,
Darryl Received on Wed Aug 29 2001 - 13:09:46 CDT