| 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 Swanson | 29 Oct |
| • Re: float comparison? | Scott Gifford | 30 Oct |
| • Re: float comparison? | Hassan Schroeder | 30 Oct |
| • Hi all | Fabricio Mota | 30 Oct |
| • Re: float comparison? | Michael Stassen | 31 Oct |
| • Re: float comparison? | Scott Gifford | 31 Oct |
| • Re: float comparison? | Joerg Bruehe | 31 Oct |
| • RE: RES: Hi all | SST - Adelaide) | 1 Nov |
| • RES: RES: Hi all | Fabricio Mota | 1 Nov |
