character_length

Return the number of characters in a string

Syntax

char[acter]_length(string_expr)

Arguments

string_expr

A character string or an expression returning a character string value.

Description

This function returns the number of characters in the specified string expression including any trailing blanks but not including the null terminator.

Example

select char_length("1234567890");
char_length("1234567890")
                        10

select char_length(L"1234567890");
char_length(L"1234567890")
                        10