Hi
it's easy

--- In firebird-support@yahoogroups.com, Christian Gütter <news@g...>
wrote:

> NameAll := Name1 + #13#10 + Name2;
>
> I guess that in SQL it must be something like:
>
> NameAll = Name1 || ??? || Name2
>
> My problem is that I do not know how CR/LF is represented in
> SQL.

NameAll = Name1 || '
' || Name2
You can insert cr/lf between '

Regards,
Eugeney Putilin