Hi,

I was hoping somone could help. I need to count the number of words in a specfic column in a table if i didn't know what the words said.

I can count the number of words using

DECLARE @String VARCHAR(4000)
SET @String = ' words to be counted'

SELECT LEN(@String) - LEN(REPLACE(@String, ' ', '')) + 1

AS Results

but this requires me to know what the words are and not count them from the column.