I've found the easiest way is to use the 'CAST' function. Say my select reads: SELECT AMTDUE FROM INVOICES; and that return a left aligned string of values. Changing the statement to SELECT CAST(AMTDUE AS DECIMAL(10,2)) AS AmtDue FROM INVOICES; and run it, now I have a right justified column of numbers.