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 · Accepted solution]

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