How do I format a DOUBLE?

[apattin]

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]

I would cast it to DECIMAL

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/