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 resul

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