Padl

The Padl() function keeps prepending 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 prepended as many times as necessary until the indicated length is reached. Returns Invalid expression if input values do not match required type.

Syntax

Padl(value, text_length, char)

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

Padl("forty-two", 15, "WORD") => "WWWWWWforty-two" (only the FIRST character of the prepend text is used!)

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 prepend. If this value has more than 1 character, then the first character is taken.