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.R., Dothan, ALYour technical staff is very good! Everyone I have live chatted with has, for the most part, solved the issue on the first pass.
