Move PO Box to ADDRESS Field

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
Kristen
Moderator
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Move PO Box to ADDRESS Field

Post by Kristen » Fri Aug 28, 2009 3:46 pm

If you have an ADDRESS and an ADDRESS2 field in your database and you want to move the PO Box information to the ADDRESS field so that it will attempt to be validated first, run the command below BEFORE Validation:

Code: Select all

ALTER TABLE ALIAS() ADD COLUMN tempadd C(50) 
Replace tempadd with ALLT(address),address with ALLT(address2),address2 with ALLT(tempadd),tempadd with "" FOR "PO BOX" $ UPPER(address2) OR "P.O. BOX" $ UPPER(Address2)

Post Reply