title: T-SQL - how to round DOWN to nearest .05
body: <p>The database I am using is SQL Server 2005. I am trying to round values DOWN to the nearest .05 (nickel).</p>
  
  <p>So far I have:</p>
  
  <p><code>SELECT ROUND(numberToBeRounded / 5, 2) * 5</code></p>
  
  <p>which <em>almost</em> works - what I need is for the expression, when <strong>numberToBeRounded</strong> is <strong>1.99</strong>, to evaluate to <strong>1.95</strong>, not <strong>2</strong>.</p>