Reference material for LPAD function
Parameter | Description | Supported input types | |
---|---|---|---|
<expression> | The original string. If the length of the original string is larger than the length parameter, this function removes the overflowing characters from the string. | TEXT | |
<value> | The length of the string as an integer after it has been left-padded. | INTEGER | |
<pad> | The string to add to the start of the primary string <expression> . If left blank, <pad> defaults to whitespace characters. | TEXT |
TEXT