title: Rounding issue with SQL Server and REAL datatype
body: <p>I'm seeing some strange behavior when rounding in SQL Server 2008. Given the following code:</p>
  
  <pre><code>DECLARE @Value REAL
  SELECT @Value = .35
  SELECT ROUND(@Value, 1)
  </code></pre>
  
  <p>I would expect the value to be .4, however it outputs .3. I must assume this is because the value stored is actually less than .35, something like .34999999999999. Is this the case, or am I doing something wrong? Is there a way to ensure this behaves as expected, at least from the visible value?</p>