The Padr() function keeps appending a single character to a text until a specified length is reached.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a new text where the indicated character is appended as many times as necessary until the indicated length is reached.
Returns Invalid expression if input does not match required type.
| Name | Type | Required | Description |
|---|---|---|---|
value
text, numeric
a text or a number.
length
numeric
the number of characters in the resulting text.
char
text
the character to append. If this value has more than 1 character, then only the
first character is taken.