Prefixing Zeros to the data in the table to make it 5 characters
502776Mar 28 2007 — edited May 18 2007i have to take data from a table having one column and load into another table.
having one column. It is a varchar column which stores numbers
The data in table 1 is having less than 5 characaters like '456','23','1' etc
But when i insert it into another table i should prefix zeros to make it 5 characters and insert, like '00456','00023','00001'
Please help me of how to do it
Message was edited by:
Michael Armstrong