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