Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRISOpens in a new window, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions pageOpens in a new window (login required).


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




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



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

See Also

FeedbackOpens in a new window