Count words in table

[sql]
SELECT SUM( LENGTH(myfield) – LENGTH(REPLACE(myfield, ‘ ‘, ”))+1) as nreg
FROM myTable
[/sql]

Posted on 8 de Maio de 2012 by . This entry was posted in SQL. Bookmark the permalink.

Comments are closed.