modify column from number to char and lpad with zero
Is there a way to alter a table column from number to char and lpad the data with zero?
The easiest means I can currently think of is to create another table with the correct column definition and then select * the data from the original table using the lpad function into the new table.
Looking for something more elegant.