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

I refer AccuZIP because of the customer service. You have a live person that answers phone calls and fields them to the correct person for help. On top of that each of your technicians knows their stuff! They are always helpful.
T.P., Spartanburg, SC