Adding a line feed or carrage return to a field.

I have the following statement in a Developer report

decode(ADDRESS1,NULL,NULL,address1||chr(13)) ||
decode(ADDRESS2,NULL,NULL,address2||chr(13)) ||
decode(ADDRESS3,NULL,NULL,address3||chr(13)) as addy,

I would like it to desplay

Address1
Address2
Address3

At the moment it all stays on the same line .... I have tried char(10) and combinations of (10) and (13) but to no avail .... any idea's ?

--

James Alexander Starritt (james_at_jamesstarritt.com)