Subject Re: [firebird-support] String delimiter
Author Helen Borrie
At 04:59 AM 1/08/2003 +0000, you wrote:
>Firebird Quick Start Guide 1.1 states ...
>
>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.

Not on my system it doesn't.

SQL> SELECT 'abc;def' AS OUTPUT FROM RDB$DATABASE;

OUTPUT
==================
'abc;def'

What tool are you using?

heLen