15.9.11 rpad(value1, value2, value3)

RPad(text-exp , length [,pad-exp]) - Function pads the right-side of a string with a specific set of characters (when string1 is not null). : RPAD

Value 1: text-exp - A text expression that you want to pad. Value can be one of the following types: text.

Value 2: length - The total length of the return value as it is displayed on your screen. Value can be one of the following types: integer.

Value 3: pad-exp - A text expression that specifies the padding characters. The default value of pad-exp is a single blank. Value can be one of the following types: text.

Returned value will be of type text.

Function Result

rpad("Levi Cruz", 25, "a")

Levi Cruzaaaaaaaaaaaaaaaa