Move Address2 into Address if Address is empty.
Posted: Thu Aug 15, 2013 2:29 pm
If you have ADDRESS 2 information but your ADDRESS is blank. The following command will move the ADDRESS 2 information into the ADDRESS. If the ADDRESS field is empty.
Code: Select all
Replace address with ALLT(address2),address2 with "" FOR EMPTY(address)