At 10:31 am 1/13/2004, you wrote:
Could you CAST them first, then apply MIN?
> -----Original Message----- > From: Eldon Ziegler [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 13, 2004 9:56 AM > To: [EMAIL PROTECTED] > Subject: MIN with negative numbers in VARCHAR > > > 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] > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]