RPAD

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Pads a string on the right to a specified length.

1rpad(<string>, <length> [, fill])

• <string>: The string to pad.
• <length>: The desired total length.

• fill: The padding characters. Defaults to space.

Returns a text value padded to the specified length.

• If the string is longer than the specified length, it is truncated.
• The fill string is repeated as needed.

Pad a string on the right.

1SELECT rpad('hi', 5, 'xy') AS result;

Returns 'hixyx'.

• String Types