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)) |
K.H., Winchester, VAYour technical support people have been wonderful. I want to thank you for all your help. Accuzip6 is really a first rate organization.
