Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Built-in Functions/ String Functions/ rpad
Updated on 2023-10-25 GMT+08:00
View PDF
Share

rpad

This function is used to right pad str1 with str2 to the specified length.

Syntax

rpad(string <str1>, int <length>, string <str2>)

Parameters

Table 1 Parameters

Parameter

Mandatory

Type

Description

str1

Yes

STRING

String to be right-padded

length

Yes

INT

Number of digits to be padded to the right

str2

Yes

STRING

String used for padding

Return Values

The return value is of the STRING type.

  • If the value of length is smaller than the number of digits in str1, the string whose length is truncated from the left of str1 is returned.
  • If the value of length is 0, an empty string is returned.
  • If there is no input parameter or the value of any input parameter is NULL, NULL is returned.

Example Code

The value hi??? is returned.

SELECT rpad('hi', 5, '??');

The value h is returned.

SELECT rpad('hi', 1, '??');
Parent topic: String Functions