Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

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)