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.B., Montoursville PAThings are going well with AccuZIP. My mailings are running smoothly, and for the 3rd month in a row my mailer scorecard has been perfect.
