Dan Guzman - Not the MVP (12/30/2009)
Great explanation Scott, that's very detailed and instructive. Unfortunately it does not address the behavior found by KevinC. Why is not the behavior you describe consistent in a given range of numbers?Dan
It haven't checked, but I am pretty sure it does address the behaviour found - because the binary (IEEE) representation of these numbers will not be "consistent".
Basically it boils dow to "Don't use ROUND() with double-precision"
Kelsey Thornton
MBCS CITP