I've moved a databse from prod to dev and a calculation on a sum of a float column gives a different value. There are approx 16k rows and here are the results ( so you can see the difference )
-648365.80999999424
-648365.81000000483

The data is identical as I've checked it, assuming data compare can be trusted < grin > and the dev db is a restored backup from production.

I seem to remember something about the float datatype from way back when, which is why i don't personally use it, however this is a client database. collation etc. is the same - anyone any ideas?

thanks so very much - that was what I thought but couldn't find anything in my searches. I needed an outside confirmation from an "authority"  and who better than yourself.

thankyou