SQL rounding problem
Hello EE,
lets say I have this code:
DEClare @test decimal(10, 4)
set @test = 333.3334
How could I do a select that returns 2 decimals, but like that: 333.34
because I have a 4 at the end... I would like to show 333.34
the thing is that I saved inside table as money and it saves 4 decimals. I have a 4 at the fourth decimal.
any ideas.. ?
lets say I have this code:
DEClare @test decimal(10, 4)
set @test = 333.3334
How could I do a select that returns 2 decimals, but like that: 333.34
because I have a 4 at the end... I would like to show 333.34
the thing is that I saved inside table as money and it saves 4 decimals. I have a 4 at the fourth decimal.
any ideas.. ?
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ahhh floor works....!
thanks angel
thanks angel
ASKER
sorry I meant Ceiling *100
select Round(@test, 2)