title: sql rounding up to a multiple of 5?
body: <p>Hello i was wondering is there a way to round up to a multiple of 5 in SQL?</p>
  
  <p>For example this only rounds up to ten if i set @Order = 8 or 9 but when it's 7 or 6 it rounds down to 5, i need it to round up to 10 when it's 6 or 7.</p>
  
  <pre><code>declare @Order int
  
  set @Order = 7
  
  select round(cast(@Order as float)/cast(5 as float),0)*5
  </code></pre>
  
  <p>I need </p>
  
  <ul>
  <li><code>@Order = 1,2,3,4</code> to round up to 5</li>
  <li><code>@Order = 6,7,8,9</code> to round up to 10</li>
  <li><code>@Order = 11,12,13,14</code> to round up to 15</li>
  </ul>