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)) |
T.M., Chapel Hill, NCI’ve really enjoyed working with your company. Your customer service is the best and your product is as well!
