Re: how to display inverted quote '

Lai wrote:
>
> Hi,
>
> I want to display a text that contains the inverted quote '. how to do
> that? I've tried this:
>
> select 'I\'m here' from dual;
>
> It doesn't work.

Nice try, but SQL is not C. To encode an apostrophe within a string literal, double it:

    select 'I''m here' from dual;

Scott McKellar mck9_at_swbell.net Received on Wed Jun 16 1999 - 04:48:09 CEST