| Subject | RE: [firebird-support] quotation marks >" |
|---|---|
| Author | Norman Dunbar |
| Post date | 2003-07-25T10:37:50Z |
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.
Cheers,
Norm.
-------------------------------------
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:33 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] quotation marks >"<
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/
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.
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.
Cheers,
Norm.
-------------------------------------
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:33 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] quotation marks >"<
> Try :In fact it works!
>
> insert into ...
> values ( ' This has a quote " in it ' )
>
> Using single quotes to delimit the valus that has a double quote in it.
>
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/
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.