Extract text after specific text string

Hi guys,   I am trying to get location code from the column Subject in table FACT_Tasks - example below:   Logic: If Subject contains (anywhere) the specific text string (AAAA or BBBB), then - I...