How to take apart information between hyphens in SQL Server

Question

How would I take apart a column that contains string:

92873-987dsfkj80-2002-04-11
20392-208kj48384-2008-01-04

Data would look like this:

Filename     Yes/No     Key
Abidabo      Yes        92873-987dsfkj80-2002-04-11
Bibiboo      No         20392-208kj48384-2008-01-04

Want it to look like this:

Filename     Yes/No     Key
Abidabo      Yes        92873-987dsfkj80-20020411
Bibiboo      No         20392-208kj48384-20080104

whereby I would like to concat the dates in the end as 20020411 and 20080104. From the right side, the information is the same always. From the left it is not, otherwise I could have concatenated it. It is not an import issue.

Answer 1

As mentioned in the comments already, storing data like this is a bad idea. However, you can obtain the dates from those strings by using a RIGHT function like so:

SELECT RIGHT('20392-208kj48384-2008-01-04', 10) 

Output:

2008-01-04