RPAD()

All functions > STRING > RPAD()

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

Signatures

Returns: String padded on the right to the specified length

RPAD(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
    -- Pad with dashes
    f1 := RPAD('hello', 10, '-'),
    -- Zero padding
    f2 := RPAD('123', 7, '0'),
    -- Multi-character padding
    f3 := RPAD('AB', 6, 'XY'),
    -- Truncation when too long
    f4 := RPAD('hello', 3, '-'),
    -- No padding needed
    f5 := RPAD('test', 4, ' '),
    -- NULL pad yields NULL
    f6 := RPAD('a', 4, NULL(VARCHAR))
;