SQL tidy up address data
Posted on 2014-03-14
I have an address table from which I need to print address labels. ie
Address1, Address2, Address3, PostalCode
Some of these fields are empty, so I want the next available field to be in the position of the missing data so when printed the address is on consecutive lines with no spaces.
Note address2 is missing, but there is no place holder for where it should be.
Any idea on how I can achieve this?