Returns the length of a string expression as a large integer. The argument must be a string expression. The expression cannot be a mixed character expression. The result is the number of characters in the argument (not the number of bytes).
Example:
Assume column ADDRESS has a value of '895 Don Mills Road'.
CHARACTER_LENGTH(ADDRESS)
Returns the value 18.