title: Round off to next 0.05 in SQL Server
body: <p>I have a requirement, where I need the rates to be rounded off to nearest nickel.
  For e.g:</p>
  
  <p><strong>Rate</strong> . . . .     <strong>Rounded Value</strong><br>
  1.90 . . . .  1.90<br>
  1.91 . . . .     1.95<br>
  1.92 . . . .     1.95<br>
  1.93 . . . .     1.95<br>
  1.94 . . . .     1.95<br>
  1.95 . . . .     1.95<br>
  1.96 . . . .     2.00<br>
  1.97 . . . .     2.00<br>
  1.98 . . . .     2.00<br>
  1.99 . . . .     2.00<br>
  2.00 . . . .    2.00  </p>
  
  <p>i.e if the <strong>'hunderedth' place after decimal has to be rounded off to its next 0.05</strong>.<br>
  I have written a query which gives me value <em>for nearest 0.05 not to next 0.05</em>.  </p>
  
  <pre><code>select Rate, (Round((Rate)/0.25 , 2)*0.25) as RoundRate   from ProposedProductPrice order by created desc
  </code></pre>