How can I add a leading zero to all my post codes?
Hey guys, I have a table with over 1000 store locations. I have imported them via CSV. The stores are located in Germany, so they have 5 digit post codes. But some of these post codes begin with a 0, so 01234 for example. Unfortunately, the 0 was removed after the import... Now some post codes are like this: 1234, while they should be 01234. How can I select all post codes with only 4 digits and add a leading zero to it?
