Lpad
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.