--CEILING ROUND
TO UP
SELECT CEILING(2.3) ---------Round to 3
SELECT CEILING(2.6) ---------Round to 3
--FLOOR ROUND TO
DOWN
SELECT FLOOR(2.9) -----------Round to 2
SELECT FLOOR(2.4) -----------Round to 2
----What I need
is 2.6 rounds up to 3. Also 2.4 rounds to 2.
SELECT ROUND(yourvalue,0)
SELECT ROUND(2.6,0)----------Round to 3
SELECT ROUND(2.4,0)----------Round to 2