SQL Server/T-SQL/Math Functions/CEILING

CEILING(-98.1)

   <source lang="sql">

1> SELECT CEILING(-98.1) 2> GO

---

 -98

(1 rows affected) 1>

      </source>
   
  

CEILING(-98.9)

   <source lang="sql">

2> SELECT CEILING(-98.9) 3> GO

---

 -98

(1 rows affected)

      </source>
   
  

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

   <source lang="sql">

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>

      </source>