SingleStore Managed Service

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 |
+------------+