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