How to: |
The ATODBL function converts a number in alphanumeric format to decimal (double-precision) format.
ATODBL(source_string, length, output)
where:
Is the string consisting of digits and, optionally, one sign and one decimal point to be converted.
Is the length of the source string in bytes. This can be a numeric constant, or a field or variable that contains the value. If you specify a numeric constant, enclose it in single quotation marks, for example '12'.
ATODBL converts EMP_ID into double-precision format.
ATODBL(EMP_ID, '09', 'D12.2')
For 112847612, the result is 112,847,612.00.
For 117593129, the result is 117,593,129.00.
WebFOCUS | |
Feedback |