1> --PATINDEX: searchs for a pattern of characters within a string.2> -- return 0 if no match is found.3>4> SELECT PATINDEX("%SQL%","SQL server sql server")5>6> GO----------- 1(1 rows affected)1>