title: Rounding down decimal numbers in SQL Server 2008
body: <p>I read all rounding functions of T-SQL like <code>Round</code>, <code>Floor</code>, and <code>Ceil</code>, but none of them has rounded down decimal numbers correctly for me.</p>
  
  <p>I have 2 questions:</p>
  
  <ol>
  <li>How to round down a decimal number (<code>3.69</code> ==> <code>3.5</code>)?</li>
  <li>How to round up the last 3 digits of an integer (e.g. <code>142600</code> ==> <code>143000</code>)?</li>
  </ol>