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

Just had to write and tell you I got the update and I tell you, your product just gets gooder and gooder!   I love it! Keep up the wonderful work!
P.C., Auburn, AL