How to count duplicate characters using sql server

Question

How to count duplicate characters using sql server

for example

place: chennai  from that i want to count number of n's from chennai using sqlserver 2000

thanks

Rgds,
narasiman P