Comparing two floating point numbers for equality seldom works the way you want it to.Without seeing the exact data you have it's hard to say for sure (as theremay be some other issue with what you're doing) but I wouldn't expect this to work with data from arbitrary sources. Try SELECT * FROM mytable WHERE myreal >= 10.49 AND myreal <= 10.51; and see what result that gives.
This way, it works... Philippe Ferreira.
