Re: How to insert a ' into an field

Oliver Huppert wrote:

> Hi there
>
> I've to insert a String conaining a ' into an table.
> The SQL-Statement:
>
> insert into [table] values ('14 jours après l'implantation');
>
> or so
>
> don't work, because of the ' after the l. Oracle means the String ends here.
>
> Plsease help me.
>
> Nice regards
> Oliver Huppert

Hi Oliver,
Just double the quote mark, like so:

    insert into [table] values ('14 jours après l''implantation');

HTH,
Avi. Received on Wed Oct 11 2000 - 01:30:50 CDT