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