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" |
T.A., Grand Rapids, MIWhile we have consistently been impressed with the level of assistance we receive through your online chat portal, Geoff has been more than helpful and great to work with on every issue we’ve come across. He is quick to diagnose and resolve the issues. He also has offered to instruction and information to prevent future issues. He has even guided us through some functions of Accuzip we had not previously been utilizing. I wanted to take a minute and give a huge shout out to Geoff.
