Hi all,
We're using UDF 8.2.
How does one format a DOUBLE to, for example, 2 decimal digits? Sort of
like sprintf in C where you'd give a format pattern such as 4.2F . I
cannot find any formatting built-in functions. Using CHAR(my_double)
results in the number being presented in exponential form; DIGITS does
not work for DOUBLEs...
Thanks,
Alejandrina
Serge Rielau - 30 Jun 2006 22:24 GMT
> Hi all,
>
[quoted text clipped - 5 lines]
> results in the number being presented in exponential form; DIGITS does
> not work for DOUBLEs...
I would cast it to DECIMAL

Signature
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/