How to: |
TO_NUMBER converts a character string that contains a valid number consisting of digits and an optional decimal point to the numeric format most appropriate to the context. If the value does not represent a valid number, zero (0) is returned.
TO_NUMBER(string)
where:
TO_NUMBER converts the string '56.78' to a number with one decimal place.
TO_NUMBER('56.78')
The result is 56.8.
WebFOCUS | |
Feedback |