Define number of characters

max_hfr

Hi guys,

I have a column which contains some id (only numbers). the number of characters can vary eg: 012345 or 01234 or 1234. 

I order to upload my output to a server i need this column's length to have exactly 11 characters.

So i Would need  012345 to become 00000012345,  01234 to become 00000001234,  1234 to become 00000001234

Any idea?

Thanks in advance

DavidP

You can use the padleft function. Make sure your column is a string with length of 11 characters.