Hi, select YourField from YourTable order by YourField limit 1;
Best regards, Mikhail. ----- Original Message ----- From: "A Z" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 11, 2004 3:01 PM Subject: Max > > Hi, > > A field of type VarChar() with following syntax: > ABA1. > How to get the Max value. Bearing in mind that value > ABA10 comes before ABA2. > > regards > > > > > > > ____________________________________________________________ > Yahoo! Messenger - Communicate instantly..."Ping" > your friends today! Download Messenger Now > http://uk.messenger.yahoo.com/download/index.html > > -- > 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]