Skip to main content

LEN (SQL)

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

Synopsis

LEN(string-expression)

Description

LEN returns the number of characters in a string expression

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

Arguments

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.

See Also

FeedbackOpens in a new tab