CHARINDEX « String Functions « SQL Server / T-SQL

1.CHARINDEX: returns the starting point of the first occurrence of one string of characters within another string
2.CHARINDEX(): find the first occurrence of a substring within another string
3.CHARINDEX('Mars', 'The stars near Mars are far from ours')
4.CHARINDEX: Get index of the delimiting space
5.Combine CHARINDEX with substring