Teradata RPAD function is used to add repeated characters at the end of a string to increase the string to a specified length. It can be used to add trailing space or zeros to a string.
RPAD function signature
RPAD(source_string, length, fill_string)
Returns the source_stringpadded to the right with the characters in fill_stringso that the resulting string is lengthcharacters.
Pad with trailing zeros
SELECT RPAD('123456789',23,'0');
Result:
'12345678900000000000000'
Omit fill\_string parameter
The last parameter is optional. When it is omitted, the default value is space (' ')
Example:
SELECT RPAD('123456789',23);
Result:
'123456789 '