Skip to main content
Previous sectionNext section

LEN

A string function that returns the number of characters in a string expression.

Synopsis

LEN(string-expression)

Arguments

Argument Description
string-expression A string expression, which can be the name of a column, a string literal, or the result of another scalar function, where the underlying data type can be represented as any character type (such as CHAR or VARCHAR).

LEN returns the INTEGER data type.

Description

Note:

The LEN function is an alias for the LENGTH function. LEN is provided for TSQL compatibility. Refer to LENGTH for further details.

See Also