MIN with negative numbers in VARCHAR

[Eldon Ziegler]

We have a table with floating point measurement values stored in VARCHAR's. 
How can I get MIN in SELECT to evaluate these as numbers instead of strings 
so negative value sort correctly? Right now I've kludged it as 
MIN(SIGN(Value) * ABS(Value)). Is there a more straight forward way?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]