當您的 T0.name 是字元歸檔時,您應該如下取代 Order By -order by case when cast(left (T0.Name,2) as int)>=8 then cast(left (T0.Name,2) as int)-8 else cast(left (T0.Name,2) as int)+4 end登入後複製