Write a query to find the occurrence of character in the given string in SQL Server

Published --