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) |
T.R., San Luis Obispo, CAI’m influenced and impressed by the AccuZIP support personnel you have. We had setup issues on Friday and I was jamming things through my mail department and wanted to be able to use AccuTrace THAT DAY. It was important for my client. As a result I phoned support and spoke to a wonderfully pleasant woman who was extremely knowledgeable, polite and helpful. Donna whom I believe lived in Georgia was the representative. She is a treasure.
