Parameter | Type | Description |
---|---|---|
str | string | the string to right pad |
length | integer | the length to pad the string to |
pad | string | an optional padding character |
Returns: string
Example
query:
SELECT RPAD("Pickles", 10, "!")
results:
rpad |
---|
Pickles!!! |
The string function used to right-pad a string to a given length, using a given character (or space, if no character is given).
Parameter | Type | Description |
---|---|---|
str | string | the string to right pad |
length | integer | the length to pad the string to |
pad | string | an optional padding character |
query:
SELECT RPAD("Pickles", 10, "!")
results:
rpad |
---|
Pickles!!! |