>>>
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.
If it's not broken, fix it until it is.
My Blog