Hi Guys,DECLARE @Float1 float, @Float2 float, @Float3 float, @Float4 float; SET @Float1 = 64.99 SET @Float2 = 4.71 SET @Float3 = @Float1 + @Float2select @Float3 as f3 SELECT @Float3 - @Float1 as f4
f3 = 69.7f4 = 4.70999999999999Why does float just mess up the scale to such an extend?Another thing, I am using float datatype to store money in my application. I have few limitations from the front end where in they use double which doesnot accept decimal output. Do we have any known issues with using float as a storage datatype for curency?
Float datatype
Posted - 2011-11-21 : 18:01:56
