select distinct的结果如何按12345排序

Question

select distinct PalletNo from TRA_Pallet order by PalletNo

出来的结果是这样的

 

现在希望能够按1,2,3,4,5...来排序，怎么做

Answer 1

排序字段转数字
select distinct PalletNo from TRA_Pallet order by (PalletNo +0)