Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section


A function that returns the number of characters in an expression.




Argument Description
expression An expression, which can be the name of a column, a string literal, or the result of another scalar function. The underlying data type can be a character type (such as CHAR or VARCHAR), a numeric, or a data stream.



The DATALENGTH, CHAR_LENGTH, and CHARACTER_LENGTH functions are identical. Use of the CHAR_LENGTH function is recommended for new code. DATALENGTH is provided for TSQL compatibility. Refer to CHAR_LENGTH for further details.

See Also

FeedbackOpens in a new window