TO_NUMBER
The TO_NUMBER function returns a DECFLOAT(34) value that is based on the interpretation of the input string using the specified format.
The TO_NUMBER function is identical to the DECFLOAT_FORMAT function. For more information, see DECFLOAT_FORMAT.