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