一列里面有D1,D2, D3, D4...............D100， 如果排序如何进行查询

[@more@]order by to_number(trim('D' from fab.SERIAL_NUMBER))