RPAD
This is the same as the LPAD function except that the padding takes place on the right of the returned string. This code returns the string “Hi!!!”:
LPAD
SELECT RPAD('Hi', '5', '!');