title: sql server round function not working well
body: <p>I am using sql server 2000 and facing round function issue like the following statement working fine. </p>
  
  <pre><code>SELECT ROUND(5 * 7.83, 1)
  </code></pre>
  
  <p>The result will be 39.2</p>
  
  <p>But when I get these values from the table, it gives 39.1, meaning it truncates and does not round up.</p>
  
  <pre><code>SELECT ROUND(rate * qty, 1) 
    FROM tbl
  </code></pre>
  
  <p>The result will be 39.1</p>
  
  <p><code>rate</code> and <code>qty</code> columns data types are float.  Insert 5 in <code>qty</code> and 7.83 in <code>rate</code>, then check it.  How I can fix it?</p>