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

Many thanks for your support on this holiday. As always, Accuzip Tech Support comes through when I need you.

P.D., P.D., Silver Spring, MD