Try to use UDF ASCII_CHAR(10)

declaration is

DECLARE EXTERNAL FUNCTION ascii_char
INTEGER
RETURNS CSTRING(1) FREE_IT
ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';

> It is possible to accomplish a consultation that gives back a returns intermediate?
>
> Example: select a.name || chr(10) || a.description as name from test a
>