Re: How to insert a ' into an field

From: <svemulapalli_at_my-deja.com>
Date: Tue, 10 Oct 2000 12:50:33 GMT
Message-ID: <8rv3an$uo2$1@nnrp1.deja.com>

use two single quote where ever quote exists in your string e.g :
insert into [table] values ('14 jours après l''implantation'); Suresh

In article <39e2fa9a_at_news.netfab.de>,
"Oliver Huppert" <ohuppert_at_pikon.com> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 10 2000 - 07:50:33 CDT