Carriage return in STRING_AGG function

[marcelgerr]

I am having some difficulty trying to add multiple strings into a parameter field seperated by a line feed. So far I have come up with the following:

SELECT STRING_AGG ('some varchar field', BINTOSTR( HEXTOBIN('0D0A') )) FROM table1 but that generates the following error:

feature not supported: non-deterministic function is not allowed in constant expression

Any suggestions are more than welcome.

Regards,
Marcel.

[marcelgerr]

I already fixed the problem like so:

SELECT STRING_AGG ('some varchar field', '

') FROM table1