Skip to content

Latest commit

 

History

History
42 lines (32 loc) · 764 Bytes

lpad.md

File metadata and controls

42 lines (32 loc) · 764 Bytes
title
LPAD

Returns the string str, left-padded with the string padstr to a length of len characters. If str is longer than len, the return value is shortened to len characters.

Syntax

LPAD(<str>, <len>, <padstr>)

Arguments

Arguments Description
<str> The string.
<len> The length.
<padstr> The pad string.

Return Type

VARCHAR

Examples

SELECT LPAD('hi',4,'??');
+---------------------+
| LPAD('hi', 4, '??') |
+---------------------+
| ??hi                |
+---------------------+

SELECT LPAD('hi',1,'??');
+---------------------+
| LPAD('hi', 1, '??') |
+---------------------+
| h                   |
+---------------------+