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.W., Hobe Sound, FLWe love the database and how simple it is for us to make simple codes as our business always has since 1955...We are grateful to you and your staff that take client service so seriously.
