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.

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.

Last updated

Was this helpful?