Oracle reports v 6 (&crm ebusiness)--sql query, of using decode

Hiyas

I am currently working on Oracle Report which ties in with my a report in the ebusiness suite of Oracle telesales module.

Basically, the address on statement reports have blank fields (null) where the customer does not have and address2, address 3,

At present its set up to read customers
ADDRESS1
CITY
COUNTY
POSTAL CODE But if the customer does have an address 2 or 3 fields I can do this by adding in ADDRESS2 AND ADDRESS3 to both my SQL Query and report. However, not all addresses have 2nd & 3rd Address fields, hence all the other statments will appear as 'null fields' making the address for some customers gappy?

I want to write a DECODE statement whereby, if ADDRESS2 AND ADDRESS3 are NULL to skip to the next field being 'CITY'?

Please help...

Cheers Received on Fri Feb 20 2004 - 14:06:21 CET