{ CHARACTER_LENGTH | CHAR_LENGTH } ( string_expression ) Syntax Elementsstring_expression The string expression for which the length is to be returned. The type of string_expression must be CHARACTER, VARCHAR, or CLOB. For non-character data types, the function returns an error.