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)) |
C.W., Los Angeles, CAWe spoke with several different companies and even had samples sent to us. We chose AccuZIP6 and I have never been happier about spending over $1000 on software in my life.
