Post reply

Always round up

  • June 23, 2009 at 11:28 am

    #139196

    Hi all,

    I want to ALWAYS round up to the nearest whole number. The ROUND function won't do this. So for example:

    SELECT ROUND(170.1,0) will return 170. I want it to return 171

    SELECT ROUND(1.4999,0) will return 1. I want it to return 2

    Is there another way I should be doing this?

    Thanks,

    Strick

  • June 23, 2009 at 11:45 am

    #1014141

    Use ceiling: select ceiling(170.1) -- will return 171

  • June 23, 2009 at 1:38 pm

    #1014228

    Great thanks!

    Strick

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply