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
1
: 3132 At:- 8/7/2018 2:30:01 PM
SQL count the occurrence of specific word



add comment to question



2 Answers
profileImage 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

count-occurence-of-string-sql-min.png

Above is the sample output.
2
At:- 8/8/2018 4:06:18 PM


comment to above answer
profileImage Answered by:- LuneAgile

Thanks so much Vilas.
0
At:- 8/8/2018 5:57:37 PM


comment to above answer

Patreon Become a Patron


Login/Register to answer
Or
Register directly by posting answer/details

Full Name *

Email *




By posting your answer you agree on privacy policy & terms of use

Related Articles
11721
WITH in SQL (Examples included using SQL server)
8700
Row constructor in SQL server (Explanation With example)
5674
Ways to prevent SQL injection in PHP
8673
Creating SQL Server maintenance plan (Step by step procedure)
4772
How to fix "SQL server configuration manager cannot connect to wmi provider" error?

Subscribe Now

Subscribe to our weekly Newsletter & Keep getting latest article/questions in your inbox weekly


Related Questions