title: How to truncate the decimal values in sql server 2000
body: <p>I have a expression:</p>
  
  <pre><code>Select (2345789 * 39.456) / 100 
  </code></pre>
  
  <p>The output is <code>925554.5078400</code>.</p>
  
  <p>I would like to display <code>925554.50</code> i.e. 2 values after decimal.</p>
  
  <p>If I use round </p>
  
  <pre><code>Select round((2345789 * 39.456)/100, 1)
  </code></pre>
  
  <p>the output is <code>925554.5000000</code>. But I want exactly 2 digits after the decimal. How to do that?</p>