This statement returns all rows:
Select column12 from mytable
Column12 datatype is "real"
From this, I pick a random value from in the rows returned:
for example, -1.399726E+08
copy an paste it into an this :
Select column12 from mytable where column12 =-1.399726E+08
This returns a null, no row found and returned
Is the query value I'm seeing in the intial query, ( -1.399726E+08 ) not exactly what's in the table?
What's going in here?