JaimeJegonia
asked on
Convert Integer into a fix Char column
Dear Experts,
How can I convert an Integer Column into a fix Char Column like as follows:
Integer Column Char (7) Column
7 ----- 0000007
8 0000008
9 0000009
10 0000010
100 0000100
1000 0001000
Any lead will be greatly apprciated.
Thanks.
How can I convert an Integer Column into a fix Char Column like as follows:
Integer Column Char (7) Column
7 ----- 0000007
8 0000008
9 0000009
10 0000010
100 0000100
1000 0001000
Any lead will be greatly apprciated.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
thanks for Grade 'B'
ASKER
Thanks you saved me hours.