Subject | Re: [firebird-support] String delimiter |
---|---|
Author | Helen Borrie |
Post date | 2003-08-01T05:20:04Z |
At 04:59 AM 1/08/2003 +0000, you wrote:
SQL> SELECT 'abc;def' AS OUTPUT FROM RDB$DATABASE;
OUTPUT
==================
'abc;def'
What tool are you using?
heLen
>Firebird Quick Start Guide 1.1 states ...Not on my system it doesn't.
>
>If you need to use an apostrophe inside a Firebird string, you
>can "escape" the apostrophe character by
>preceding it with another apostrophe.
>
>
>.... Accepted.
>
>What about using ; in strings -->
>
>gives an error -> -104 Unexpected end of statement
>
>'stri;ng' gives error.
SQL> SELECT 'abc;def' AS OUTPUT FROM RDB$DATABASE;
OUTPUT
==================
'abc;def'
What tool are you using?
heLen