CHARINDEX is a SQL function that searches an expression (char or string) in given expression and
return start position if matches found. If matches not found it return 0.
Syntax:
CHARINDEX(Expressio1,
Expression2, [Start_Location])
Where,
Expression1:
String to be look for in expression2
Start_Location: It
means from where to start looking for expression1 in expression2.
NOTE:
It returns bigint
if expression2 is of verchar(max), nvarchar(max), varbinary(max) datatypes,
else it returns int.
Example:
