select *, cast(pole as number) as sortpole from table order by sortpole desc или так: select * from table order by cast(pole as number) desc