Subject RE: [firebird-support] quotation marks >"
Author Norman Dunbar
Being awkwward now eh :o)

to get a single quote in a column :

insert into ...
values ' O''Malley'

That's a single quote, O, two single quotes together, Malley, single quote.

Which results in the column being set to O'Malley - with only one quote.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
Tel: 0113 289 6265
Fax: 0113 289 3146

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

> 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 " ?


To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to

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.