How can i modify the following query in DB2
(CAST(SUBS_REFI LL_COUPONNO_CHA NNELID AS INTEGER) (FORMAT '9(16)') (CHAR(16)) )
where SUBS_REFILL_COU PONNO_CHANNELID is the column name of my table that contains 12,14 & 16 digit number. but i want all the numbers in 16 digit by adding the as many zero in the front, when i am using select query.
e.g. 678978654543 should be displayed as 000067897865454 3
67897865454312 should be displayed as 006789786545431 2
pls help
(CAST(SUBS_REFI LL_COUPONNO_CHA NNELID AS INTEGER) (FORMAT '9(16)') (CHAR(16)) )
where SUBS_REFILL_COU PONNO_CHANNELID is the column name of my table that contains 12,14 & 16 digit number. but i want all the numbers in 16 digit by adding the as many zero in the front, when i am using select query.
e.g. 678978654543 should be displayed as 000067897865454 3
67897865454312 should be displayed as 006789786545431 2
pls help
Comment