# LEFT, RIGHT, LPAD, RPAD
__*LEFT function*__
__*RIGHT function*__
__*LPAD function*__
__*RPAD function*__
+ `LEFT(str, numchar), RIGHT(str, numchar)`: Returns the leftmost or rightmost**numchar** character in a string
+ `LPAD(str, len, padstr), RPAD(str, len, padstr)`: Returns a string padded with**padstr** on the left or right side, no more than**len** characters in length
+ For example:
  + `SELECT left('TSO',1), right('TSO',2), lpad('TSO',4,'#'), rpad('TSO',4,'#');`  
```10
tidb> SELECT left('TSO',1), right('TSO',2), lpad('TSO',4,'#'), rpad('TSO',4,'#');
+---------------+----------------+-------------------+-------------------+
| LEFT('TSO',1) | RIGHT('TSO',2) | LPAD('TSO',4,'#') | RPAD('TSO',4,'#') |
+---------------+----------------+-------------------+-------------------+
| T             | SO             | #TSO              | TSO#              |
+---------------+----------------+-------------------+-------------------+
```

------------------------------------------------------------
- LEFT () return the leftmost character of the specified length
- RIGHT () return the rightmost character of the specified number
- LPAD () return a string parameter and adds the specified string to the left
- RPAD () adds a string a specified number of times