List:General Discussion« Previous MessageNext Message »
From:Jerry Swanson Date:October 29 2005 3:50pm
Subject:float comparison?
View as plain text  
Why when I do select from database and try to compare float field with float
number, I have no results

amount --- type float

select * from price where amount = 3.45 // doesn't work
select * from price where amount = '3.45' //doesn't work

select * from price where amoun like '3.45' //work

My question is how to compare float field with float number. What operator I
should use?

Thread
float comparison?Jerry Swanson29 Oct
  • Re: float comparison?Scott Gifford30 Oct
    • Re: float comparison?Hassan Schroeder30 Oct
      • Hi allFabricio Mota30 Oct
      • Re: float comparison?Michael Stassen31 Oct
        • Re: float comparison?Scott Gifford31 Oct
    • Re: float comparison?Joerg Bruehe31 Oct
RE: RES: Hi allSST - Adelaide)1 Nov
  • RES: RES: Hi allFabricio Mota1 Nov