Search code examples
sql-servermathrounding

Round *UP* to the nearest 100 in SQL Server

Is it possible to easily round a figure up to the nearest 100 (or 1000, 500, 200 etc.) in SQL Server?

So:

720 -> 800
790 -> 800
1401 -> 1500

Solution

  • The following should work. After reading your question, I'm not exactly sure what you want 100 to return. For this 100 returns 100.

    select floor((X + 99) / 100) * 100;

    This gives the following results:

    0 -> 0
1 -> 100
99 -> 100
100 -> 100
101 -> 200