Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

6.8 KiB

Raw Permalink Blame History

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

6.8 KiB Raw Permalink Blame History