Rounding NUMBERS IN SQL

See more:

SQL-Server-2005

SQL-Server

i want to round numbers in sql
but there 's 1 condition with fraction
for example

declare @x float

select @x=34.44 --> in this is case i want @x=34
select @x=34.6 --> in this is case i want @x=35
select @x=34.5--> in this is case i want @x=34.5

meaning
if the fraction is less than 50% then work like floor function
if the fraction is greater thqn 50% then work like ceiling function
if the fraction is equl 50% do nothing

so i need help in that