Word count

Words in a column are easily counted using the splendid example I picked up on the net.

SELECT(LEN(column) - LEN(REPLACE(column, ' ', ''))) + 1
FROM table