charindex vs patindex in sql

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