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" |
M.M., Scottsdale, AZI have been working in pretty much all areas of senior-level IT and Data Processing for many years and have had countless hours of experience engaging with customer support. I’ve never had better support than what I receive from Accuzip! Seriously, any time I call, email, or go to the online chat, someone responds in less than a minute, is always very patient and pleasant, and resolves my issue quickly. Aside from just fixing the problem, your support team always takes the time to explain what the problem was and how to prevent it. It is very refreshing and encouraging to see that real support still exists. Thanks to the Accuzip Team! I look forward to many more years of engagement with your Team.
