From: mcstockX@Xenquery   
      
   "etravels"  wrote in message   
   news:d1569ff3.0402200506.30cbbdea@posting.google.com...   
   | 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   
      
   you might want to try just setting Vertical Elasticity property for the   
   fields   
      
   regarding the decode, you can use the standard syntax [ decode ( expression,   
   match1, display1, match2, display2.... default)  ] on the concatenation of   
   ADDRESS2 and ADDRESS3,   
   or use a decode for each, appending the expression(s) to the address1   
   column. don't forget to imbed a newline with the appended address line(s)   
      
   -{ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)