>>>>
PADL(MTON(yAmount),9,'0')
>>>>
>>>Thanks. I haven't used this function before.
>>
>>Neither did I. I avoid using Money/Currency data types because it requires special handling in some cases w/o providing any advantages over numeric data types.
>
>We're using Currency here for all amount fields. BTW, I just realized we better would use Borislav's idea, because we need 2 digits after ., not 4.
Naomi,
TRANSFORM(money_here) depends of SET DECIMALS, so be careful :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
