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).

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