Outdated Version

You are viewing an older version of this section. View current production version.

RPAD

Pads the end of a string up to the specified character length.

Syntax

RPAD (str, len, padding)

Arguments

  • str: any string or binary object
  • len: total length of the string
  • padding: the characters to pad with

Return Type

String

Examples

SELECT RPAD('ohai',10,'_') as o;
+------------+
| o          |
+------------+
| ohai______ |
+------------+

SELECT RPAD('123',10,'0') as o;
+------------+
| o          |
+------------+
| 1230000000 |
+------------+

Related Topics