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