LPAD

Pad the string on the left side with “ABC” until it reaches a total length of 20 characters.

SELECT LPAD(“SQL Tutorial”, 20, “ABC”);

Definition and Usage

The LPAD() function adds padding to the left side of a string with another string until it reaches a specified length.

Note: Additionally, consider the RPAD() function for padding on the right side.

LPAD(string, length, lpad_string)

Parameter	Description
string	Input required: The original string. If the length of the original string exceeds the specified length parameter, this function removes any overflowing characters from the string.
length	Input required: The desired length of the string after left-padding has been applied.
lpad_string	Input required: The string used for left-padding.

Works in:

From MySQL 4.0

Pad the text in the “CustomerName” column on the left side with “ABC” until it reaches a total length of 30 characters.

SELECT LPAD(CustomerName, 30, “ABC”) AS LeftPadCustomerName
FROM Customers;