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