Hello list
Got strings in the format "integer+(char)^0..1", ex 3456, 2323, 2324A,
2324B, ...
I want to order them as they where integers, like:
order by cast(STING as unsigned) desc
But when using that query resulting in error 1292. And the result are not
correct.
How can I remove the chars before i casting the string? And if possible take
the chars in the order.
So that i get a result like: 1000, 1000A, 1000B, 900, 800, 800A.
//M
PS
Sorry for spelling and grammar
DS
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.10/875 - Release Date: 2007-06-27
21:08
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
