Find Number of Occurence of a Character is String in SQL

Here I have find occurrence of  character 'r' in string  'khargesh kumar rajput'.