CHARINDEX « String Functions « SQL Server / T-SQL Tutorial

12.3.1.CHARINDEX returns the starting point of the first occurrence of one string within another string.
12.3.2.Get index of the delimiting space
12.3.3.SELECT CHARINDEX('Mars', 'The stars near Mars are far from ours') CHARINDEX('SQL', ' SQL Server') CHARINDEX('-', '(559) 555-1212')
12.3.6.Finding the Start Position of a String Within Another String