1> -- 2>3> SELECT CHARINDEX('Mars', 'The stars near Mars are far from ours')4>5> GO----------- 16(1 rows affected)1>