Re: How to insert a ' into an field

Or use CHR(39), but then CHR(39) has to be the ' That may depend on the codepage of your OS.

insert into [table] values ('14 jours après l' || CHR(39) || 'implantation');
 Arie Mars
arie_at_pca-online.nl

<svemulapalli_at_my-deja.com> schreef in berichtnieuws 8rv3an$uo2$1_at_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 Thu Oct 12 2000 - 04:22:15 CDT