Better to use CAST INT/CEILING/FLOOR: SELECT CEILING(1235.53) SELECT FLOOR(1235.53) SELECT CAST(1235.53 AS INT)