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