Rpad() mvSQL database function in Jitterbit App Builder¶
Summary¶
The RPAD function returns a copy of the string that is right-padded to the total number of characters that the length argument specifies.
Syntax¶
RPAD(<string>, <length>, <padchar>)
Parameters¶
string¶
The string to pad.
length¶
The desired length.
padchar¶
The character to pad with if the desired length is greater than the current string length.
Returns¶
A padded string.
Examples¶
RPAD('HelloWorld', 8, '0')
Returns
lloWorld
RPAD('HelloWorld', 12, '0')
Returns
HelloWorld00