rounding - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

rounding

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-10-03 : 04:21:38

Dear All,
i Just want to round of near by zero
like

if it is 0.3 then 0.5
if it is 0.8 then 1.0
if it's 0.2 then 0

How can i do this

please help me
Regards
Krishnakuamr.C

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-10-03 : 04:54:55

[code]round(val / 5, 1) * 5[/code]

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-10-03 : 05:00:41

-- testing script

declare @table table
(
	val	decimal(10,2)
)
-- create data
insert into @table 
select	NUMBER * 0.1
from	F_TABLE_NUMBER_RANGE(1,20)

select 	*, convert(decimal(10,2), round(val / 5, 1) * 5)
from	@table