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)) |
T.P., Spartanburg, NCThis is the reason I feel so comfortable in recommending AccuZIP to other Allegra’s . Below is an email….subject line really… “Donna is AWESOME!” that I just received from a Philly center. Not just Donna but all customer facing AccuZIP employees are AWESOME!
