Dear All,

The conversion method mentioned above, was also tried before and it gave me the alignment as

Amount
4,55,658.90
0.00
22,565.80

etc like this. The alignment mentioned in my first thread was after converting the number field with the conversion that was mentioned in the reply. Is there some other way, which will align the number fields? This lpad(to_char(amt,FM)) works fine in the SQL prompt, with the correct alignment. But it doesnt work fine with the Form Builder.

regards
ranjini