title: Round *UP* to the nearest 100 in SQL Server
body: <p>Is it possible to easily round a figure <b>up</b> to the nearest 100 (or 1000, 500, 200 etc.) in SQL Server?</p>
  
  <p>So:</p>
  
  <p>720 -> 800<br/>
  790 -> 800<br/>
  1401 -> 1500<br/></p>