Aligning Decimals
Top  Previous  Next

The following example shows how you can use the FORMAT function to align decimal points in a column:

   SELECT (FORMAT(bonuspct,'99.000')) FROM salesbonus

The following example shows the effect of the FORMAT function on the above SELECT statement:

Using FORMAT
Without FORMAT
0.003
0.003
0.002
0.002
0.000
0
0.001
0.001