Re: The ' character

Hi Natalia,

Natalia wrote:
>
> This should be very simple, but I completely can't find the answer. How
> do you specify the ' inside a string. I tried using an escape character
> in front of it, but SQL still takes it a the designator for the end of
> the string. You know, how would you put O'Connor into the system?

select 'O''Connor' as theName from dual

-- 
Uwe Schneider       | Telefon +49 7251 / 82587
Karlsdorfer Str. 31 | Mail    pi_at_richard-schneider.de
DE-76646 Bruchsal   | http://www.richard-schneider.de/uwe
Linux - OS al dente!