PATINDEX searches for a pattern of characters within a string
PATINDEX is not case sensitive. PATINDEX returns 0 if no match is found. PATINDEX allows the handling of wildcards, unlike CHARINDEX. 12> SELECT PATINDEX("%rntsoft%","This is www.rntsoft.com") 13> 14> GO ----------- 13 (1 rows affected)