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