CHARINDEX


 * https://docs.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql?view=sql-server-2017

CHARINDEX ( expressionToFind, expressionToSearch [ , start_location ] )

select CHARINDEX('Test','Search this text as a test')

23