Count the number of words in a field
In this command, the number of words in the Address field will be tabulated in a field named countadd:
|
ALTER TABLE ALIAS() ADD COLUMN countadd C(10) REPLACE ALL countadd WITH TRANSFORM(WORDS(address)) |
C.P., Houston, TXFirst the kudos. Accuzip, already the best, is even better with the new CASS speed. I don't know how you did it but it is fast, fast, fast!
