padding with zero according to field size!
Dear All,
I want to add leading zeros, as per numeric column width while selecting data through sql query. Kindly let me know how to do this.
For example if in a table there is field empID number(3)
Now if the data is
1
23
999
45
7
The result i should get should be:
001
023
999
045
007
Thanks, Imran