Padr

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.

Syntax

Padr(value, text_length, char)

Padr("forty-two", 15, ".") => "forty-two......"

Padr("forty-two", 15, "WORD") => "forty-twoWWWWWW"

Parameters

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.