declare @value float set @value = 123456.78912340 select @value, round(@value, 1), round(@value, 0), round(@value, -1) select @value, round(@value, 2, 0), round(@value, 2, 1)