How to count the occurrence of specific word inside a string in sql server 2008?

Hi. Suppose, I have for example this string field in my sql database "never say never" and I want to count how many times "never" appear in the string in sql server 2008, so how I can check that.

Thanks.

Asked by:- LuneAgile

: 2961 At:- 8/7/2018 2:30:01 PM

SQL count the occurrence of specific word

add comment to question

2 Answers

Answered by:- vikas_jk

Here is the working example

    Declare @string VARCHAR(MAX) ='Never say Never'
	DECLARE @tosearch VARCHAR(MAX)='Never'  
      
    SELECT (DATALENGTH(@string)-DATALENGTH(REPLACE(@string,@tosearch,'')))/DATALENGTH(@tosearch)  
    AS OccurrenceCount