SQL Server how to round money variable up if decimal part is the same or greater than 0.5 : <p>I have a variable @value with type <code>money</code> and need to round it up if it's the same or greater than 0.5 and down otherwise. Some examples:</p>

<pre><code>2.5 --&gt; 3
2.4999 --&gt; 2
2.5001 --&gt; 3
2.4 --&gt; 2
2.7 --&gt; 3
</code></pre>
