CHARACTER_LENGTH or CHAR_LENGTH

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.