How to Round up and Round-down value ?

--pass your value to @yourvalue and execute the query

declare @yourvalue decimal(4,2)
select @yourvalue = 3.75
declare @roundpart int
set @roundpart=floor(@yourvalue)
declare @des int
set @des =PARSENAME(@yourvalue,1)
if(@des>=75)
begin
 set @yourvalue= convert(decimal(4,2) ,@roundpart+1)
PRINT  @yourvalue
end
else
begin
set @yourvalue=convert(decimal(4,2), convert(varchar(10),@roundpart)+'.50')
print	@yourvalue
end