How to order a string as integer

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

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

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/mysql?unsub=lists@pantek.com