You just need to duplicate your quote character (string delimiter). Examples:

select ' "A" ''B'' ' from rdb$database;

insert into ... values (' "A" ''B'' ');

Note that around are single double-quotes and that around B are double single-quotes.

Regards,
Daniel Berstein.

On 25 Jul 2003 at 20:37, Geoffrey M. Ongley wrote:

> I'm not sure about firebird specifically, but I'd try
> \" to delimit the quotation marks...
>
> eg ("A quote \"with this quote\" 'and this one' as I use both quotation
> marks");
>
>
> On Fri, 25 Jul 2003 10:33 am, Robert Razniewski wrote:
> > > Try :
> > >
> > > insert into ...
> > > values ( ' This has a quote " in it ' )
> > >
> > > Using single quotes to delimit the valus that has a double quote in it.
> >
> > In fact it works!
> > But, if I need both: ' and " ?
> >
> > rr
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>