PATINDEX

String functions in MS SQL SERVER

Transact-SQL string and datetime functions

CHARINDEX and PATINDEX functions

String functions in MS SQL SERVER