I want to concat Address, city ,state and zip to one string. Some times address is null, sometimes city, state and zip are null.
I want in this format
Address, City, State-Zip
if Address is missing then I want
If City, State and Zip are missing then I want
Right now I am getting it. But do not know how to get rid of the ',' after address when there is no city state and zip.
Thanks in advance.