You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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

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

memsql> SELECT LPAD('123',10,'0') as o;
+------------+
| o          |
+------------+
| 0000000123 |
+------------+

Related Topics