SQL Function Reference

RPAD
Returns a string right-padded with another string to the specified length
MySQL
RPAD(str, len, pad_str)
str
Source string
len
The length of the string to which the string will be padded
pad_str
The string to be padded with the original string
Examples
MySQL
SELECT RPAD('9', 5, '0')