Right-pad a string. This function pads a string on the right side with a specified string until it reaches a certain length.
RPAD(str, len [, padstr])Returns the string str, right-padded with the string padstr to a length of len characters. If str is longer than len, the return value is shortened to len characters. If padstr is omitted, the RPAD function pads spaces.
Returns NULL if given a NULL argument. If the result is empty (a length of zero), returns either an empty string, or, with , NULL.
The Oracle mode version of the function can be accessed outside of Oracle mode by using RPAD_ORACLE as the function name.
With the pad string defaulting to space:
Oracle mode:
- Left-padding instead of right-padding.
This page is licensed: GPLv2, originally from
SELECT RPAD('hello',10,'.');
+----------------------+
| RPAD('hello',10,'.') |
+----------------------+
| hello..... |
+----------------------+
SELECT RPAD('hello',2,'.');
+---------------------+
| RPAD('hello',2,'.') |
+---------------------+
| he |
+---------------------+SELECT RPAD('hello',30);
+--------------------------------+
| RPAD('hello',30) |
+--------------------------------+
| hello |
+--------------------------------+SELECT RPAD('',0),RPAD_ORACLE('',0);
+------------+-------------------+
| RPAD('',0) | RPAD_ORACLE('',0) |
+------------+-------------------+
| | NULL |
+------------+-------------------+