From: Date: October 31 2005 5:52pm Subject: Re: float comparison? List-Archive: http://lists.mysql.com/mysql/191066 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Michael Stassen writes: >> Scott Gifford wrote: [...] >>>Try something like this: >>> >>> select * from price where amount > 3.44 and amount <= 3.46 > > I hope the "<=" was a typo? Yes. ----Scott.