How to Count No. of Occurences of a Character in a String

13-Oct-0909 Leave a comment

 
 
LEN(ColumnToCheck) – LEN(REPLACE(ColumnToCheck,"N",""))
 
If it is more complex then see
 
 

Filed under SQL Server