Fmt function for decimal data type

monaz · Post by **monaz** » Sat Oct 11, 2008 4:00 am

Hi all,

I have an problem with FMT function. I have requirement where i have to do RIGHT ALIGN Space fill for decimal field.

eg:- Quantity- decimal(17,4) is the input given

OutPut:- < 645.0000>

So to do right align space fill i wrote the below derivation for quantity filed as

FMT(Quantity, "17' 'R").

But the does not works out its failng.

Please correct me if anything is missing

ArndW · Post by **ArndW** » Sat Oct 11, 2008 4:49 am

The FMT(x,"17' 'R") statement will do what you stated you want done. Could you post your source data and the failed result of the format so that we could understand what didn't work?