Support 805.461.7300
Sales
Our Technology. Your Success.

Erase Address2 when Apt number is in Address & Address2

If you find that some of the records in your database have apartment number information in the address field and that information is duplicated in the address2 field, this command deletes the information out of address2 when there is a match.

REPLACE address2 WITH "" FOR ALLT(UPPER(address2)) $ UPPER(address)

« Back to Commands

I refer AccuZIP because of the customer service. You have a live person that answers phone calls and fields them to the correct person for help. On top of that each of your technicians knows their stuff! They are always helpful.
T.P., Spartanburg, SC