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) |
K.P., Colorado Springs, COI just wanted to share how FABULOUS [Geoff] is and you should keep him for sure! I have had the best service and training from him in the last few days that it has sold me on keeping AccuZIP @ my new job. I was new to this software and learning in “trial by fire” mode and he got me thru it without any burns! He is amazing and deserves a raise, bonus, employee of year- SOMETHING BIG. I have dealt with the mail industry for about 30 years and never received this level of support and so positive. I am forever grateful and will suggest him and this product if asked. I am being very serious about his knowledge, skill, and interpersonal skill(hard to find these days).
