Thanks a lot, it worked with the double datatype!
On Fri, 14 Jun 2002, Michael Ivanyo wrote:
> I've had similar problems with this in my career and
> have come to the conclusion that one should always use
> double floats. The problem is typically due to round
> off errors of the float
"select version();"
"show create table ...;"
- Original Message -
From: "Vandana" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 7:01 PM
Subject: A simple query, please help
>
> My table is as follows:
>
> Value Distance
>(float) (float)
>