On Tuesday 19 May 2009 19:33:56 Adriano dos Santos Fernandes wrote:

> All,
>
> Oracle has a feature where you can use quotes inside strings without
> need to double them.
>
> Here is a example:
> select q'!where name = 'xyz'!' from dual;
> Result: where name = 'xyz'
>
> And another one:
> select q'{where name = 'xyz'}' from dual;
> Result: where name = 'xyz'
>
> When the opening character is "[", "{", "(" or "<", the closing one is
> respectively "]", "}", ")" and ">". In other cases, the opening and
> closing shall be identical.
>
> The strings really terminates in <close char><quote>, so you can even
> use that character inside it.
>
> I propose the same thing for Firebird.

Does it mean that in the old program literal '{ABC}' will actually
become 'ABC'?