LEN (SQL)
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.
