Hello gotze,

counting words in a field may be tried with [ depends on SQL database ]

SELECT (1 + LENGTH(Field_Name) - LENGTH(REPLACE(Field_Name, ' ', ''))) AS Word_Count from Table_Name

-- you supply Field_Name and Table_Name in above.

-- may not work [ not tested ] with double spaces between words and / or foreign character sets.


And to total all the words in a field for the table try :

SELECT sum((1 + LENGTH(Field_Name) - LENGTH(REPLACE(Field_Name, ' ', '')))) AS Word_Total from Table_Name

Have a try.

Thanks cornball