Support 805.461.7300
Sales
Our Technology. Your Success.

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))

« Back to Commands

Prior to Accuzip we used SAP Postalsoft. We looked for its replacement and chose Accuzip based on testimonials of how great customer service was and on pricing which was very attractive. Best move we've ever made in software and you folks live up to all the good things I heard. I still get calls every 6 months from FirstLogic ( a distributer of the old Postalsoft and others) to see if I'm still happy with Accuzip. I always say the same thing: Yes, very happy. Thanks for checking in.
B.H., Newtown, PA