Compare address in all records and mark the longest
Posted: Thu Oct 28, 2010 4:09 pm
The command below counts the number of characters in the field named Address and marks the record that has the largest number of characters.
Code: Select all
comFieldName="address" SELECT MAX(LEN(allt(&comFieldName))) FROM (ALIAS()) INTO ARRAY _longest LOCATE FOR LEN(allt(&comFieldName))=_longest(1) REPLACE x WITH "X"