Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
RPAD
Pads the end of a string up to the specified character length.
Syntax
RPAD (str, len, padding)
Arguments
- str: any string or binary object
- len: total length of the string
- padding: the characters to pad with
Return Type
String
Examples
SELECT RPAD('ohai',10,'_') as o;
+------------+
| o |
+------------+
| ohai______ |
+------------+
SELECT RPAD('123',10,'0') as o;
+------------+
| o |
+------------+
| 1230000000 |
+------------+
