Try :

insert into ...
values ( ' This has a quote " in it ' )

Using single quotes to delimit the valus that has a double quote in it.

Regards,
Norman.

-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar@...
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------


-----Original Message-----
From: Robert Razniewski [mailto:gustaf@...]
Sent: Friday, July 25, 2003 11:18 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] quotation marks >"<


Yes. I know. But I need specially "


This email is intended only for the use of the addressees named above and may be confidential or legally privileged. If you are not an addressee you must not read it and must not use any information contained in it, nor copy it, nor inform any person other than Lynx Financial Systems or the addressees of its existence or contents. If you have received this email and are not a named addressee, please delete it and notify the Lynx Financial Systems IT Department on 0113 2892990.