Need to edge out the competition for your dream job? Train for certifications today.
SELECT column1, LEN(column1)-LEN(REPLACE(column1, ' ', ''))+1 Words FROM Table1;
Open in new window
declare @someTable table
[someColumn] varchar(100) not null
insert into @someTable values
,('I love Fruit')
,('Fox Jumps Over the Fence')
select [someColumn], len([someColumn]) - len(replace([someColumn], ' ', '')) + 1 [wordCount]
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.