Re: SELECT with REAL...

> Comparing two floating point numbers for equality seldom works
> the way you want it to.
>
> Without seeing the exact data you have it's hard to say for sure (as
> there
> may be some other issue with what you're doing) but I wouldn't expect
> this to work with data from arbitrary sources.
>
> Try
>
>   SELECT * FROM mytable WHERE myreal >= 10.49 AND myreal <= 10.51;
>
> and see what result that gives.
>
This way, it works...

Philippe Ferreira.