How can you find the number of occurrences of a particular character in a string using sql?

Example: I want to find the number of times the letter ‘d’ appears in this string.

declare @string varchar(100)
select @string = 'sfdasadhfasjfdlsajflsadsadsdadsa'

​x
 
declare @string varchar(100)select @string = 'sfdasadhfasjfdlsajflsadsadsdadsa'​

Answer

Here you go:

declare @string varchar(100)
select @string = 'sfdasadhfasjfdlsajflsadsadsdadsa'
SELECT LEN(@string) - LEN(REPLACE(@string, 'd', '')) AS D_Count

 
declare @string varchar(100)select @string = 'sfdasadhfasjfdlsajflsadsadsdadsa'SELECT LEN(@string) - LEN(REPLACE(@string, 'd', '')) AS D_Count​