rpad
function
Applies to: Databricks SQL Databricks Runtime
Returns expr
, right-padded with pad
to a length of len
.
rpad(expr, len [, pad] )
expr
: ASTRING
orBINARY
expression to be padded.len
: AnINTEGER
expression.pad
: An optionalSTRING
orBINARY
expression with the pattern for padding. The default is a space character forSTRING
and x’00’ forBINARY
.
A BINARY
if both expr
and pad
are BINARY
. Otherwise, returns a STRING
.
If expr
is longer than len
, the return value is shortened to len
characters.
If you do not specify pad
, a STRING
expr
is padded to the right with space characters, whereas a BINARY
expr
is padded to the right with x’00’ bytes.
If len
is less than 1, an empty string.
BINARY
is supported since: Databricks Runtime 11.0.
> SELECT rpad('hi', 5, 'ab');
hiaba
> SELECT rpad('hi', 1, '??');
h
> SELECT rpad('hi', 5);
hi
> SELECT hex(rpad(x'1020', 5, x'05'))
1020050505