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

Re: How to order a string as integer

On 6/28/07, Magnus Borg [EMAIL PROTECTED] wrote: 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