I have three columns in my table:
netcost integer(9,2)
taxsum integer(9,2)
quantity integer
In my SELECT I have:
SELECT (netcost+taxsum)*quantity AS totalcost FROM etc etc
My problem is that the value in totalcost is, like, 49.500000000000
SELECT round((netcost+taxsum)*quantity, 2) AS totalcost FROM etc etc
gives the same result. What I want is 2DP, ie 49.50 in this example. Is there a way to achieve this?
TIA and for past help.
Michael Rowan
mike(dot)rowan(at)internode(dot)on(dot)net
11 Kingscote Street
ALBERTON
South Australia 5014
tel 618 8240 3993