How to use a carriage return in a literal string in TDV

[Jolanda van Gilst 2]

I've experimented with several statements:

select 'test line 1'||'rn'||'test line 2';

result:test line 1rntest line 2

 

select 'test line 1'||chr(13)||'test line 2';

result:test line 1 test line 2

 

I want the result to be:

test line 1

test line 2