RPAD
Returns a VARCHAR value representing a string of a specific length filled on the right with specific characters.
Behavior Type
Syntax
RPAD ( expression , length [ , fill ] )
Parameters
expression |
(CHAR OR VARCHAR) specifies the string to fill |
length |
(INTEGER) specifies the number of characters to return |
fill |
(CHAR OR VARCHAR) specifies the repeating string of characters with which to fill the output string. The default is the space character. |
Examples
=> SELECT RPAD('database', 15, 'xzy'); RPAD ----------------- databasexzyxzyx (1 row)
If the string is already longer than the specified length it is truncated on the right:
=> SELECT RPAD('database', 6, 'xzy'); RPAD -------- databa (1 row)