Tony Rogerson in his weblog posted about Counting the number of words in a string Here are two more methods 1 Using the method I posted already about Squeeze Function to remove multiple spaces Declare @s varchar ( 100 ) set @s = ' See how many words this has ' Select len ( string )- len ( replace ( string...