Floating point problem

[de Laitre Francois]

Hi,

I'm using mysql version 3.23 and I have the following problem :

> SELECT (1.57 + 0.42 - 1.57 - 0.42).
> Result : -0.00

The result is -0.1.10^-17. What can I do to have 0.00 and not -0.00 ?

In the documentation, they say that this problem cannot be solved using ROUND() or similar functions. I understand this problem but I don't know how to fix it.

Does someone know how to fix it, please ?

Thanks

Francois