find a text within string in sql

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