length

Return the number of characters in a string

Syntax

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 excluding any trailing blanks and the null terminator.

Example

select length("1234567890     ");
length("1234567890     ")
                        10

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