• I've figured it out using a combination of Substring and Charindex!