LPAD

​

Syntax

​

Scalar

lpad(value, length [, fill])

​

Arguments

​

Returns

• Type: STRING
• Possible values: A padded/truncated string; negative lengths act as zero and return an empty string.
• NULL behavior: Returns NULL when any supplied argument is NULL.

​

Properties

​

Usage notes

• An empty fill string supplies no padding; the original string is retained when it is shorter than the requested length.
• The fill pattern repeats and is truncated to the required character count.

​

Examples

​

Typical behavior

SELECT lpad('abc', 6, 'xy') AS padded, lpad('abc', 2, 'xy') AS truncated;

​

Pad with spaces by default

SELECT lpad('a', 3) AS result;

​

Limitations

• Target lengths above 2147483647 raise an execution error.