I am needing an
sql statement that will add one zero in front of the rest of the numbers that are already in a column row. For example I need all the data in a single column to be changed from "12345" to "012345".
My table name is "associate_list" and the column name is "disc". I need all the records to be updated for that column.
Thanks!!