Report question

Question: SQL query to remove certain text from each field in a specific column?