RPAD

Syntax

RPAD(str,len,padstr)

Purpose

The RPAD function pads the string str with the string padstr on the right until the length of the result is len.

• If the length of str is greater than len, the leftmost len characters of str are returned.

• If the length of str is less than len, and the combined length of str and padstr is greater than len, the leftmost len characters of the combined string are returned.

• If the length of str is less than len, and the combined length of str and padstr is less than len, the leftmost len characters of the combined string of str and multiple repetitions of padstr (total length greater than or equal to len) are returned.

Examples

obclient> SELECT RPAD('hi',5,'?');
+------------------+
| RPAD('hi',5,'?') |
+------------------+
| hi???            |
+------------------+
1 row in set

obclient> SELECT RPAD('hi',1,'?');
+------------------+
| RPAD('hi',1,'?') |
+------------------+
| h                |
+------------------+
1 row in set