I have a table where there are these fields:-
I need to update in the same table Addr1, Addr2 and Addr3 fields with the above fields data.
An example would be:-
Addr1 would be updated with POBox but if POBox IS NULL I want to update Addr1 with SubPremisesNameNumber instead. And so on..
There will be times where I need to concatenate say 'PremisesNumber' + 'Thoroughfare' and others depending on how many source fields are populated.
Hope you can help me?