docs.intersystems.com
Home  /  Application Development: Core Topics  /  InterSystems SQL Reference  /  SQL Functions  /  LEN


InterSystems SQL Reference
LEN
[Back]  [Next] 
InterSystems: The power behind what matters   
Search:  


A string function that returns the number of characters in a string expression.
Synopsis
LEN(string-expression)
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.
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