>Hi everybody,
>
>yAmount is a currency field.
>
>PADL(yAmount,9,'0') returns an empty string.
>PADL(CAST(yAmount as Numeric (9,2)),9,'0') returns the result correctly.
>
>Looks like a bug to me.
>
>Thanks in advance.
9 is not enough fo currency:
PADL(yAmount,19,'0')
PADL(TRANSFORM(yAmount),9,'0')
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.