Extract characters from string using SQL

Question

I have a column of ID's and I am needing to use SQL to extract the first two characters after the " - "

I am using the Custom SQL Query in Tableau 10.4

Example Column:

ABC - BCA - IT

AD - HD - A

QWE - QWE - E

What I need:

BC

HD

QW 

I have tried to use the substring and Charindex function but cannot seem to get it. Any ideas? 

Answer 1

You can use the following line:

select substring(example, charindex(' - ', example) + 3, 2) from (values ('ABC - BCA - IT'), ('AD - HD - A')) v(example)