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 was looking for an easy to use all-in-one postal software solution and was working with Satori Software. They quoted me $10,000.00 which was out of the realm of our budget. I was also lead to believe that they were the only solution, until I found Accuzip. I was able to save my company over $9,000.00 with one phone call to your courteous and knowledgeable sales staff. Your product does everything that we need and much much more. Thank you Accuzip!
J.S., Newark, OH