At 11:47 AM 22/06/2004 +0200, you wrote:

>Hi,
>
>I would like to do the following Delphi code sample in SQL:
>
>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.

Use the external function Ascii_char (in ib_udf):

NameAll = Name1 || Ascii_char(13)||Ascii_char(10) || Name2

/heLen