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)) |
M.S., Mt. Vernon, ILWe have over 200 vendors we work with on a daily basis and (the AccuZIP6 techs) are the most knowledgable, helpful group of folks I have worked with, always willing to go out of the way to help. As owner and GM of a Print and Mail Shop I admire the dedication these folks have in making sure we are satisfied. I also appreciate the fact that a human answers the phone.
