Im making an applications with different tables with many data. Lets look at his example what causes the trouble (This is just an example, with dummy data to make the problem clear):
| 892018 |
| 902013 |
| 902102 |
| 902119 |
| 902240 |
| 912138 |
| 912148 |
| 912181 |
| 922151 |
| 922167 |
| 922213 |
| 922236 |
| 932172 |
| 932186 |
| 932208 |
| 932244 |
| 932251 |
| 932253 |
| 20041112 |
| 20041312 |
| 20052742 |
| 20054578 |
| 20137643 |
| 20134587 |
Each ID value contains the year of appeal. The problem is that before the year 2000 the ID's contains a year of 2 numbers like 90, 91, 92 etc. How can i get a year column out of these ID's?
