Hi Thomas,

> CREATE PROCEDURE PRO_CRLF (
> FIRSTNAME VarChar(20),
> LASTNAME VarChar(40))
> AS
> declare variable fullname varchar(60);
> begin
> fullname = firstname || '
> ' || lastname;
> // ...
> end
> ^^

this works like a charm.
I put it into a selectable SP which is supposed
to work as a general utility to concatenate a
CR/LF and two strings. Great :-)


Thank you.


Christian