How to add "zeros" to a String type column ?

[sanchoniathon]

Hi,

We use Report Studio 8.3
We need to format a String type column in our list.

The column has 5 to 7 characters.

We want to format the column in order to ADD "zeros" when less than 7 characters.

For example:
12345
would become
0012345

Is this possible and how ?

Thanks !

[david.stachon]

just a semantic difference, that's not "adding" it's called concatenating.

...and in this circumstance it's called "padding":

if you're using Oracle, the function you're looking for is called: "LPAD".