Re: Insert quote into table problem

try...
insert into pctable('1011 KN','1',' 8','10','Amsterdam ','Plein ''40-''45'); where '' is not a " (double quote) but ' ' (two single quotes)

hth,
G

"PeterHageman" <P.J.J.Hageman_at_ict.hva.nl> wrote in message news:1a4cb310.0107010430.7b6843b9_at_posting.google.com...
> I'm trying to insert a row in a table, with
> a field that contains a quote.
> Sql looks like this:
> insert into pctable('1011 KN','1',' 8','10','Amsterdam ','Plein '40-'45');
> I get an error ORA 01756: quoted string not properly terminated.
> How can I get the field with 'Plein '40-'45 into the table?
>
> Greetz,
>
> Peter Hageman
> Hogeschool van Amsterdam
Received on Sun Jul 01 2001 - 08:56:01 CDT