NUM(a)

NUM(a) is a conversion function which converts the expression a to a numerical value.

NUM can be applied to character strings (data type CHAR or VARCHAR) with the code attribute ASCII, UNICODE, or BYTE, to date values, time values, timestamp values, and to numeric and Boolean values (BOOLEAN).

NUM(a)
a	Result of the NUM(a) function
`a` is a character string with the code attribute `ASCII` or `UNICODE` and can be interpreted as a numeric value	Corresponding numeric value
`a` is a character string with the code attribute `BYTE`	Value between `0` and `255` that is determined as follows: The first `Byte` of the character string is converted from hexadecimal notation to decimal notation
`a` is a numeric value	Identical numeric value (unchanged)
`a` is a Boolean value	`1`, when `a`=`TRUE` `0`, when `a`=`FALSE`
`a` is a character string that cannot be interpreted as a numeric value; `a` is a character string that does not have the code attribute `ASCII`, `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 `-9.9999999999999999999999999999999999999E+62`, `9.9999999999999999999999999999999999999E+62`	Special NULL Value
`a` is a `NULL` value	NULL Value
`a` is a special `NULL` value	Special `NULL` value