title: Round up to the nearest 500 or 1000 in SQL Server
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/3204412/round-up-to-the-nearest-100-in-sql-server">Round <em>UP</em> to the nearest 100 in SQL Server</a>  </p>
  </blockquote>
  
  
  
  <p>Is it possible to round up a figure to the nearest 500 or 1000 in SQL Server?</p>
  
  <p>Example:</p>
  
  <p>14425.00 -> 14500.00<br>
  14585.00 -> 15000.00</p>