how to find occurance of a char in a string in asp.net c#

select len('HELLO') - len(replace('HELLO','L',''))
SELECT replace('HELLO','L','')