This blog shows how to use the CharIndex function to check the index position of a string inside another string using SQL Query
Example:
SELECT CHARINDEX('String to Find',
'This is the bigger string to find something in.')
The result expected would be
20