We use the SQL CHARINDEX function to find the position of a substring or expression in a given string. We might have a character in different positions of a string. SQL CHARINDEX returns the first position and ignores the rest of matching character positions in a string.
Read more »![SQL CASE statement](https://s33046.pcdn.co/wp-content/uploads/2019/05/sql-case-statement-624x228.png)