Re: how do I insert an apostrophe

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 12 Nov 2001 22:20:59 +0100
Message-ID: <j8f0vt4bipeut8enqtsjupcqug430dand6@4ax.com>

On Mon, 12 Nov 2001 15:26:05 -0500, "Randy Harris" <Randy_at_nospam.net> wrote:

>This seems like it should be simple but I'm stumped. How can I insert a name
>with an apostrophe into a table? I've tried double quotes but get the error
>"column not allowed here".
>
>INSERT into EVENTS VALUES ( 'Info', 'More Info', "O'Brien")
>
>TIA

INSERT into EVENTS VALUES ( 'Info', 'More Info', 'O''Brien') -- escape the ' by another '

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Nov 12 2001 - 15:20:59 CST