Find Number of Occurrence of a Character is String in SQL

In previous blog, I have write query to count number of occurrence of character in string.

Now, I am writing query to find number of occurrence of any string in sentence.string count kumar in ''khargesh kumar khargesh khargesh kumar'':



And another string count khargesh.