Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

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

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