You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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

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

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

Related Topics