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.
Pads the beginning of a string up to the specified character length.
LPAD (str, len, padding)
String
SELECT LPAD('ohai',10,'_') as o;
+------------+
| o |
+------------+
| ______ohai |
+------------+
SELECT LPAD('123',10,'0') as o;
+------------+
| o |
+------------+
| 0000000123 |
+------------+