Round off to next 0.05 in SQL Server
<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>