Use the Lpad expression type to pad the left side of a string with a specific set of characters up to a given length. When you specify a value for a length that is shorter than the length of the expression, then Lpad truncates the expression to the specified length. A space is the default padding character when no character to pad is specified.
Use parameters that follow this form:
lpad(Dimension, length, "characters to pad"). For example, to pad the account value of 1234 on the left side with zeros up to five characters in length, specify:
lpad(Dimension, 5, "0") as the expression. In this example, the result is: 01234.