Example
SELECT LPAD("SQL Tutorial",
20, "ABC");Definition and Usage
The LPAD() function left-pads a string with another string, to a certain length.
Note
Also look at the RPAD() function.
Syntax
LPAD(
string
,
length
,
lpad_string
)Parameter Values
| Parameter | Description |
|---|---|
| string | Required. The original string. If the length of the original string is larger than the length parameter, this function removes the overfloating characters from string |
| length | Required. The length of the string after it has been left-padded |
| lpad_string | Required. The string to left-pad to string |
Technical Details
| Works in: | From MySQL 4.0 |
|---|