Mega Code Archive

 
Categories / MSSQL / String Functions
 

PATINDEX(%M_rs%, The stars near Mars are far from ours)

1> 2> SELECT PATINDEX('%M_rs%', 'The stars near Mars are far from ours') 3> GO -----------          16 (1 rows affected) 1>