Round up to next whole number

• Gloriann

  Ten Centuries

  Points: 1192

  More actions

  August 24, 2006 at 3:49 pm

  #173788

  Any body have any idea how I can round up to the next highest number?

  For example:  If the number is a whole number like 1 or 2 return that number.  If the number is 1.32 then return next whole number rounded up, 2.

  (The Round function seems to only change the number of decimals that are visible.)

  Thanks in advance.

• David Scotland-132255

  SSCertifiable

  Points: 5569

  More actions

  August 24, 2006 at 4:13 pm

  #656742

  How about using using the CEILING Function

  e.g. from BOL

  SELECT CEILING($123.45), CEILING($-123.45), CEILING($0.0)

  GO

  --------- --------- -------------------------

  124.00    -123.00    0.00                    

   

  hth

   

  David