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')