Forums
This topic is locked
SQL rounding numbers
Posted 19 Jul 2002 18:29:35
1
has voted
19 Jul 2002 18:29:35 Wil Turrin posted:
HiI've got some code that works, but I need to format it:
select sum(expense*.31) as expenseCalculated
from table1
how do I round the returned value to two decimal points?
Replies
Replied 20 Jul 2002 03:10:54
20 Jul 2002 03:10:54 b w replied:
In Dreamweaver in your bindings area, choose that column that returns the value you want.slide the scroll bar to the right and you can see two more headings called bindings and format. click on format and choose 2 decimals for either currency, integer or or percent.