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
ABC - BCA - IT
AD - HD - A
QWE - QWE - E
What I need:
I have tried to use the substring and Charindex function but cannot seem to get it. Any ideas?