How to find a text within string in sql server

SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.