title: Round to the closest .25
body: <p>Does anyone know of a way to round to the closest .25 in t-sql?  Currently I am rounding down using </p>
  
  <pre><code>floor(value * 4)/4
  </code></pre>
  
  <p>My client is changing their algorithm and wants to do a midpoint round to the closest quarter.  If the value is less than .125 round to 0.00, if the value is greater than or equal to .125 round up to .25.</p>