NUM(a) is a function (
conversion function) that converts the argument a to a numeric value.NUM can be applied to
character strings with the code attributes ASCII or EBCDIC (see code tables), date values, time values, timestamp values, numeric and Boolean values.|
Result of the NUM(a) function | |
a is a character string and can be interpreted as a numeric value |
Corresponding numeric value |
a is a numeric value |
Identical numeric value (unchanged) |
a is a Boolean value |
1, if a=TRUE |
a is a character string that cannot be interpreted as a numeric value; a is a character string that dos not have the code attribute ASCII or EBCDIC; a is neither a numeric nor a Boolean value. |
Error message |
a is a character string that can be interpreted as a numeric value outside the range |
Special NULL value |
a is the NULL value |
NULL value (see data type) |
a is the special NULL value |
Special NULL value |