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))

ALTER TABLE ALIAS() ADD COLUMN countadd C(10)

REPLACE ALL countadd WITH TRANSFORM(WORDS(address))

The support you offer customers is second to none. Thanks for always being there!

E.G., Milledgeville, GA