If the string contains multibyte characters, and the proper collation is being used, the number of bytes returned may be greater
than the specified number of characters.
You can specify an integer-expression that is larger than the value in the argument string expression. In this case, the entire value is returned.
This function supports NCHAR inputs and/or outputs. Whenever possible, if the input string uses character-length semantics,
the return value is described in character-length semantics.