TO_NUMBER
The TO_NUMBER function is deprecated. No warranties are provided to guarantee continued proper functionality. Converts a given string expression into a number.
Use the
CAST function for more efficient data-type conversions.
Syntax
TO_NUMBER (expression)
The expression is a column name that returns a string, string literal, or the result of another function.