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)) |
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)) |
M.F., Austin, TXAccuzip6, the best keeps getting better - and great tech support too!