# What MySQL returns, if the length of the original string is greater than the length specified as an argument in LPAD() or RPAD() functions?

MySQLMySQLi Database

In this case, MySQL will not pad anything and truncate the characters from the original string up to the value of length provided as the argument in LPAD() or RPAD() functions.

#### Example

mysql> Select LPAD('ABCD',3,'*');
+--------------------+
+--------------------+
| ABC                |
+--------------------+
1 row in set (0.00 sec)

1 row in set (0.00 sec)