Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

SELECT CHARINDEX(Mars, The stars near Mars are far from ours)

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