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.

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.

Last updated

Was this helpful?