search specific character string within string

SQL Server PATINDEX  function is a string function that returns the starting position of the first occurrence of a pattern in a specified expression.