How to count instances of character in SQL Column

Question

I have an SQL column that is a string of 100 'Y' or 'N' characters. For example:

YYNYNYYNNNYYNY...

What is the easiest way to get the count of all 'Y' symbols in each row?

Answer 1

If you are using SQL Server, then try this:

SELECT LEN(REPLACE(myColumn, 'N', '')) 

FROM ...