Teradata RPAD - Right Padding

visibility 598 access_time 2 years ago languageEnglish timeline Stats
timeline Stats
Page index 0.95

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_string padded to the right with the characters in fill_string so that the resulting string is length characters. 

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              '
info Last modified by Administrator 2 years ago copyright This page is subject to Site terms.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

More from Kontext
Create, Drop, and Truncate Table - Hive SQL
visibility 5,335
thumb_up 0
access_time 2 years ago
Teradata: PIVOT and UNPIVOT Clause
visibility 1,047
thumb_up 0
access_time 10 months ago
Teradata Tutorials Summary - October 2017
visibility 726
thumb_up 0
access_time 5 years ago