From: Jan Steinman Date: October 23 2002 5:53pm Subject: Re: Rounding floats List-Archive: http://lists.mysql.com/mysql/123071 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >From: "Michael T. Babcock" >Kenneth Hylton wrote something about SQL or QUERYs: >>I NEVER use float or double to store values like you appear to be doing... >FWIW, all of our financial database software stores values in either pennies or tenths of a cent, not dollars, to avoid decimals altogether. FLOAT + money = lawsuit :-) -- ---- SQL SQL SQL SQL SQL SQL SQL SQL ---- : Jan Steinman -- nature Transography(TM): : Bytesmiths -- artists' services: