Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to add another parameter in here

Status
Not open for further replies.

pectin232

Technical User
Jan 22, 2011
67
US
Case when trim(a.DOMESTIC_ADDRESS_LINE1) is null then a.DOMESTIC_ADDRESS_LINE1 else 'Not Available' End Address

I want to also incl if the address has an '' [Empty Set]... but tried different ways and did not work. As I pull data which is null but some are blanks which are '' I believe
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top