Product Solutions Support
Try MemSQL

LPAD

Pads the beginning of a string up to the specified character length.

LPAD (str, len, padding)

Arguments

Return Type

String

Examples

memsql> SELECT LPAD('ohai',10,'_') as o;
+------------+
| o          |
+------------+
| ______ohai |
+------------+

memsql> SELECT LPAD('123',10,'0') as o;
+------------+
| o          |
+------------+
| 0000000123 |
+------------+
Was this article useful?