Hi All, Does anyone know how to use the format() function in such a way that is displays numbers right justified. For example, see the following query, where I want no decimal places: SELECT 123456.789 AS X, FORMAT(123456.789, 0), FORMAT(123456.789, 0)+0; The 1st column is normally displayed as 123456.789 The 2nd column is displayed as string (left justified) as 123,457 BUT the 3rd column, using +0 to force right-justified, cuts off valid data and displays only 123
Cor