Decimal Point in SQL ??

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.

Try this

SELECT format(sum(TotalBil),'##0.00') as Subtotal

-------
Vincent van den Braken



[This message has been edited by Azzmodan (edited 09-09-1999).]