Outdated Version
You are viewing an older version of this section. View current production version.
LPAD
Pads the beginning of a string up to the specified character length.
Syntax
LPAD (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 LPAD('ohai',10,'_') as o;
+------------+
| o |
+------------+
| ______ohai |
+------------+
SELECT LPAD('123',10,'0') as o;
+------------+
| o |
+------------+
| 0000000123 |
+------------+
Related Topics
