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'