leo huang wrote:
Ariel,
You can try this:
mysql>select stri from prueba order by stri+0 desc;
Leo Huang
Or just make the column an INT instead of a CHAR, if you want a natural
number order. Sorting is performed differently between characters and
integers - as is obviously shown in the example.
Best regards
Mark
--
Mark Leith, Support Engineer
MySQL AB, Worcester, England, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
