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.