16.20 - RPAD - Advanced SQL Engine - Teradata Database

Purpose

Returns the source_string padded to the right with the characters in fill_string so that the resulting string is length characters.

Syntax

TD_SYSFNLIB.

Name of the database where the function is located.

source_string

A character string or string expression.

If source_string is NULL, NULL is returned.

If the length of source_string is greater than length, source_string is truncated to length characters.

length

The number of characters in the resulting string.

fill_string

The string of characters used to pad the source_string.

The sequence of characters in fill_string is replicated as necessary.

If fill_string is not specified, source_string will be padded to the right with space characters.