The NUMS function is used to determine whether the elements of a dynamic array are numeric.





If an element is numeric, a numeric string, or an empty string, it evaluates to true, and returns a value of 1 to the corresponding element in a new dynamic array. If the element is a nonnumeric string, it evaluates to false, and returns a value of 0.

The NUMS of a numeric element with a decimal point ( . ) evaluates to true; the NUMS of a numeric element with a comma ( , ) or dollar sign ( $ ) evaluates to false.

If dynamic.array evaluates to null, it returns null. If an element of dynamic.array is null, it returns null for that element.


When using the NUMS function in International Mode, the statement will use the Unicode Standard to determine whether an expression is numeric.