Re: how do I insert an apostrophe

In article <tv0c30itmidm17_at_corp.supernews.com>, Randy Harris 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")
>

Try 'O''Brien'; that should work.

• Dom>
  >