APEX

Good Morning All ~

How do you RIGHT justify a column of numbers?

I tried using LPAD as was suggested and there was no change in the result. All the numbers are still LEFT justified. Below is the script and output. I am only using LPAD for now on the Eq_Cost field until this is solved.

Select Eq_Item AS "Hardware", LPAD(TO_CHAR(Eq_Cost,'L9,999.99'), 20, ' ') AS "Our Cost",

TO_CHAR(Eq_Price, 'L99,999.99') AS "Sales Price",

TO_CHAR((Eq_Price - Eq_Cost), 'L99,999.99') AS Profit from Equipment;


Hardware Our Cost Sales Price PROFIT
Hp Laserjet CK834A $6,659.00 $7,299.00 $640.00
Apple iMac MC508LL/A $899.00 $1,199.00 $300.00
Lexmadk Pro 9500 $350.00 $399.00 $49.00
Apple iPad $500.00 $500.00 $.00
ViewSonic VX2250WM-LED 22 $249.00 $299.00 $50.00
ViewSonic VX2323WM-LED 23 $259.00 $309.00 $50.00
MS Natural Ergo Keyboard 4000 $39.00 $49.00 $10.00
Toshiba Satellite L645D Laptop $500.00 $550.00 $50.00
Apple iMac MC509LL/A $999.00 $1,299.00 $300.00
Hp Laserjet CK834A $6,659.00 $7,299.00 $640.00
10 rows returned in 0.00 seconds Download