Hello,

Is there a way to limit the number of decimal point while at the same time sum up the total in SQL??

Code E.g.

Select Dept, Sum(Totalbill, 2) AS Subtotal From Ar GROUP BY Dept order by Dept asc

Or must i use Round(Totalbill, 2) first before sum up.

Note that all this code only execute for viewing purposes using MshFlexGrid

Thks a lot.