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 string is already longer than length, it is truncated from the right
• Padding string is repeated as needed
• If padding string is longer than needed, only part of it is used

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
;