#  SUBSTRING Retrieves Part Of A String
__*SUBSTRING function*__
+ **`SUBSTRING(string, startpos [, length])`**: Returns a substring whose length does not exceed the beginning of the character in**`startpos`** 
  + If **`length`** is omitted, the substring will include all characters at the end
  + If **`startpos`** is negative, the substring is return starting at the end
```
tidb> SELECT SUBSTRING('TiDB SQL', 2), SUBSTRING('TiDB SQL', 1, 2), SUBSTRING('TiDB SQL', -2, 2);
+--------------------------+-----------------------------+------------------------------+
| SUBSTRING('TiDB SQL', 2) | SUBSTRING('TiDB SQL', 1, 2) | SUBSTRING('TiDB SQL', -2, 2) |
+--------------------------+-----------------------------+------------------------------+
| iDB SQL                  | Ti                          | QL                           |
+--------------------------+-----------------------------+------------------------------+
```

------------------------------------------------------------
- SUBSTRING () return the specified substring