Cory> The field contains 1234.5678, MySQL returns 1234.57, don't want that!
select Round (field/1000, 4) from ...
Ivan
__
One World, one Web, one Program
-- Microsoft promotional ad
Ein Volk, ein Reich, ein Fuhrer
-- Adolf Hi
Hi,
I am trying select field / 1 as Number from table1 where id = 1;
I don't want any rounding taking place, but MySQL is currently doing it.
How can I ask for a specific number of digits with division?
The field contains 1234.5678, MySQL returns 1234.57, don't want that!
Thanks,
Cory Twibe
