I have noticed a lot of discussion of comparing floating point numbers. I use a set of comparison functions that I have written based on the following article. This is a definitive guide to IEEE floating point numbers and comparisons of such. With this information you can be very specific as to exactly how inexact your floating point comparison is allowed to be. It will also explain why adding .001 or similar is never possible as a general solution.
http://www.cygnus-software.com/papers/comparingfloats/Comparing%20floating%20point%20numbers.htm Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users