T-SQL Word Count Function

 

 
 
Function

create function f_count_word_in_string (@field varchar(max), @word varchar(max))

returns int
as
begin
   return (LEN(@field) - LEN(REPLACE(@field, @word,'')))/LEN(@word)
end
 
 
 

 Test:

select dbo.f_count_word_in_string('tester

I want to test this, but how?  

oh tester tester', 'tester')

 
 Result:
 
 
 

T-SQL Word Count Function

Get the count of a specific word within a string