title: SQL Server Floating Point in WHERE clause
body: <p>I'm trying to query a database, I need to get a list of customers where their weight is equal to  60.5. The problem is that 60.5 is a real I've never query a database with a real in a where clause before.</p>
  
  <p>I've tried this:</p>
  
  <pre><code>SELECT Name FROM Customers WHERE Weight=60.5
  SELECT Name FROM Customers WHERE Weight=cast(60.5 as real)
  SELECT Name FROM Customers WHERE Weight=cast(60.5 as decimal)
  SELECT Name FROM Customers WHERE Weight=convert(real,'60.5')
  SELECT Name FROM Customers WHERE Weight=convert(decimal,'60.5')
  </code></pre>
  
  <p>These queries return 0 values but in the Customers table their are 10 rows with Weight=60.5</p>