The first character of string-expression-1 is identified as 1. If the string being searched contains more than one instance of the other string, then the CHARINDEX
function returns the position of the first instance.
If the string being searched does not contain the other string, then the CHARINDEX function returns 0.
If any of the arguments are NULL, the result is NULL.
This function supports NCHAR inputs and/or outputs.