>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.

Currency is a fixed format,
then VFP convert it to a fixed 21 chars string.

Doesn't use CAST( AS N) or MTON(), it is an program error.

Uses:

? PADL(CAST(yAmount AS M),9),"0")