select * from (Select REPLACE(LTRIM(REPLACE(cm_submittal_no, '0', ' ')), ' ', '0') orginal From prj_detail_submittal order by cm_submittal_no) asc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)