title: Float Column Equal
body: <p>I use SQL Server 2005. I have three columns in a table <code>(ref, column1, column2)</code>. Columns 1 and 2 are float, <code>ref</code> is 1, <code>column1</code> is 1000 and <code>column2</code>is 1000.</p>
  
  <pre><code>select * 
  from table 
  where ref = 1 and column1 = column2
  </code></pre>
  
  <p>returns 0 row(s)</p>
  
  <p>I converted them to decimal and they are same.</p>
  
  <p>They seem equal but query returns that they are not equal. How could it be possible?</p>
  
  <p>edit:</p>
  
  <p><a href="https://i.stack.imgur.com/sZcaA.jpg" rel="nofollow noreferrer">Here is the screenshot. They are not same. What causes this and how can i fix it?</a></p>