I have a csv file sent to me in csv. The field of interest is 8 digits. Some of those started with a 0. The field was sent numeric. So, I now have dropped some leading zeros.
I already converted the field to varchar. I now need to do this:
I have this now:
I need to have this:
I am using mysql.