SQL Server/T-SQL/Math Functions/CEILING

CEILING(-98.1)

1> SELECT CEILING(-98.1)
2> GO
-----
  -98
(1 rows affected)
1>

CEILING(-98.9)

2> SELECT CEILING(-98.9)
3> GO
-----
  -98
(1 rows affected)

CEILING: return the next integer that is larger than the number entered

47> -- CEILING: return the next integer that is larger than the number entered.
48>
49> SELECT CEILING(100.234)
50> GO
--------
     101
(1 rows affected)
1>