Example
SELECT RPAD("SQL Tutorial",
20, "ABC");Definition and Usage
The RPAD() function right-pads a string with another string, to a certain length.
Note
Also look at the LPAD() function.
Syntax
RPAD(
string
,
length
,
rpad_string
)Parameter Values
| Parameter | Description |
|---|---|
| string | Required. The original string. If the length of the original string is larger than the length parameter, this function removes the overfloating characters from string |
| length | Required. The length of the string after it has been right-padded |
| rpad_string | Required. The string to right-pad to string |
Technical Details
| Works in: | From MySQL 4.0 |
|---|