title: How to use ROUNDDOWN in sqlserver
body: <p>I want to use ROUNDDOWN function.</p>
  
  <p>When i tried using the following query,it gives me an error saying "'rounddown' is not a recognized built-in function name."</p>
  
  <pre><code>select rounddown(25.227,2)
  </code></pre>
  
  <p>My requirement is to rounddown the value to two decimals</p>
  
  <p>for ex: for value 25.22789 result should be 25.22</p>
  
  <p>and round up also</p>
  
  <p>for ex: for value 25.22789 result should be 25.23</p>
  
  <p>Any help?</p>
  
  <p>Thanks in advance</p>