[...WHERE x = 5.19? why doesn't this work?]

ok, i found that the problem is the inaccuracy in the float.  i ended up having to do a < 5.20 AND > 5.18

[...WHERE x = 5.19? why doesn't this work?]

i've tried every combination of single quotes.  do you used double quotes?

[...WHERE x = 5.19? why doesn't this work?]

Is it not possible to have a WHERE clause check if something is equal to a float?  I've tried it with both x = 5 and x = 6 and both work, so my query is fine other than this last part.  When i use any number with a decimal, I get no results.  5.19 is a valid piece of data so it should be able to find it.  Is there a way around this?

Thanks!