Hi everybody,
i have a problem with sql and can't resolve.
how can i get ID_2 from ID_1 by sql ?
ID_1 | ID_2 |
S-0000125463-ALL | 0000125463 |
SS-0000125464A-1-SEGA | 0000125464A-1 |
KBC-000025634B-2-BALL | 000025634B-2 |
separator character is always "-" but I can also have a "-" in the second part before the last "-".
thanks for your help.