Format rounding figure : 1235.00 => 1200.00

Jane · June 27th, 2003, 02:04 AM

:)hi, may i know how can I write a SQL Transact as mentioned as above>

that is if a figure is 1235.00 then i need it rouding up to 1200.00
any fixed format to convert this kind of rounding?

Thanks.

Jane

David Cameron · June 27th, 2003, 02:08 AM

Actually you are rounding that down. Anyway try using ROUND(Value, -2), eg:

DECLARE @Var Decimal(6,2)
SET @Var = 1249.00
PRINT ROUND(@Var, -2)

regards
David Cameron