how to get a position of any character in sql server

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