title: Rounding down DECIMAL(14,3) to third decimal digit in SQL 2008
body: <p>I have to round down all incoming data with type <code>DECIMAL(14,3)</code> which has 3 decimal digit to the last one. I.e.:</p>
  
  <pre><code>100; 100.0; 100.00; 100.000 -&gt; 100
  100.2; 100.02; 100.20; 100.22 -&gt; 100.xx
  </code></pre>
  
  <p>but</p>
  
  <pre><code>100.221 -&gt; 100.22
  100.229 -&gt; 100.22
  </code></pre>
  
  <p>Using which SQL operator can I check that residue of division in decimal digit is greater then zero?</p>