LPAD()

All functions > STRING > LPAD()

Returns the string padded on the left to a specified length with a padding string.

Signatures

Returns: String padded on the left to the specified length

LPAD(string: VARCHAR, length: BIGINT, padding: VARCHAR) → VARCHAR

Notes

• If the input is already longer than the target length, the result is truncated on the right
• The padding string is repeated as needed; if it is longer than the gap, only the required portion is used
• If any argument is NULL, the result is NULL (use NULL(VARCHAR) / NULL(BIGINT); bare NULL fails inference)

Examples

SELECT
    f1 := LPAD('hello', 10, '-'), -- Pad with dashes
    f2 := LPAD('123', 7, '0'), -- Zero padding
    f3 := LPAD('AB', 6, 'XY'), -- Multi-character padding
    f4 := LPAD('hello', 3, '-'), -- Truncation when too long
    f5 := LPAD('test', 4, ' '), -- No padding needed
    f6 := LPAD(NULL(VARCHAR), 5, 'x') -- NULL string yields NULL
;