patindex with wildcard in sql

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