I'm using a SQL query to populate an excel spreadsheet. One of my fields comes back as this:
Four High Risk Exposure
Three Medium Risk Exposure
Two Low Risk Exposure
I need it to read High, Medium or Low. I've got a REPLACE query running on it, but thtat will only take out the beginning or the last part. Bit stumped as to perfoming a double replace or trimming. This is my SQL query I'm currently running:
SELECT Risk.RiskTitle, OrganizationCycleMap.OrganizationElement, Risk.RiskType, REPLACE(Risk.RiskSignificance, ' Risk Exposure','') , Risk.RiskRating, Risk.RiskDescription, Controls.Control_Ref
But that leaves it as Four High, Three Medium, Two Low.