Sybase数据库中在SQL中嵌套简单逻辑判断

select * from ZL_TRAIN_TIME_TAB

 order by Fld_TrainTime_StartTime_Int,

主要是下面这句：意思是，当Fld_TrainTime_StartTime等于----时候，就把值当作9999来处理

case Fld_TrainTime_StartTime when '----' then '9999' else Fld_TrainTime_StartTime end;