hello,

I would like to create a query that returns an address.

i could do

select ADDRESS, ZIP_COPDE, CITY
from MYTABLE
...

but i would like to get the data show in that way

Address Line 1
Address line 2
ZipCode City

so i would like to know what is the way to select the CR/LF sequence
in a select clause

if could be

select ADDRESS || <CRLF> || ZIP_CODE || ' ' || CITY
from MYTABLE

My question is : How to write the <CRLF> part of the select clause ?

Thanx in advance

Julien