I think the Below logic is useful for you
convert(' ','0',(trim(convert('0',' ',Column_Name)))
Note: If u r using above logic then you have to change the column datatype like Char or Varchar
Search found 2 matches
- Mon Nov 22, 2010 4:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: remove leading zeros in decimal field in sequential file
- Replies: 26
- Views: 79552
- Sun Nov 21, 2010 3:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need Days from two Dates
- Replies: 9
- Views: 4531