I have table that has a field that isformatted as text. This is a little confusing in that the characters are actually numbers but the column needs to remain formatted as text.
My issue however is that some of the fields contain 2 characters, others contain 6, 7, 8, 9 characters, etc.
I need to somehow make them 14 characters in length with zeroes in front of whatever is there already. So for example, 14 would become 00000000000014. Or another example would be 5623 would be 00000000005623, and so forth.
How can I convert these fields to include the zeroes in front of whatever is there already?