Compare address in all records and mark the longest

The command below counts the number of characters in the field named Address and marks the record that has the largest number of characters.
You can apply this command to any field in your database simply by changing the field name.

comFieldName="address" SELECT MAX(LEN(allt(&comFieldName))) FROM (ALIAS()) INTO ARRAY _longest LOCATE FOR LEN(allt(&comFieldName))=_longest(1) REPLACE x WITH "X"

comFieldName="address"

SELECT MAX(LEN(allt(&comFieldName))) FROM (ALIAS()) INTO ARRAY _longest

LOCATE FOR LEN(allt(&comFieldName))=_longest(1)

REPLACE x WITH "X"

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

I’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.

T.R., San Luis Obispo, CA