Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?


Returns whether a value is numeric.




string An expression that resolves to a string or numeric.


The NUM function determines whether a value is numeric or non-numeric. If string is a non-numeric value, NUM returns 0. If string is a numeric value, NUM returns 1. A numeric value can contain the numerals 0 through 9, plus and minus signs, and the decimal point. NUM also returns 1 for the null string.

You can use the NUMS function to make the same determination of each element of a dynamic array.

See Also