Rounding to nearest 0.25

ROUND function lets you ROUND to the nearest boundary value or truncate to the nearest boundary value depending on the third parameter. Since you want to ROUND UP always, CEILING function would be the approprate choice.

SELECT B,CEILING(A.B*4)/4E AS B_RoundedUP
FROM	(
	    	VALUES (0.15),(0.25),(0.27),(0.49),(0.55),(1.10),(1.27)
	) AS A(B);
2 Likes