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]