Re: Adding a line feed or carrage return to a field.

"James Alexander Starritt" <james_at_jamesstarritt.com> wrote:

>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 ?

Try
decode(ADDRESS1,NULL,NULL,address1)||chr(10)||decode(ADDRESS2,NULL,NULL,address2)||chr(10)||decode(ADDRESS3,NULL,NULL,address3)

Put the chr(10) outside of the decode Received on Wed Jan 10 2001 - 15:57:00 CST