SQL Server Transact Basic to Expert - Using String Function CharIndex

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