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

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