如何通过批量更新来更改字符串数据？

I have a table (T1) in t-sql with a column (C1) that contains almost 30,000 rows of data. Each column contains values like MSA123, MSA245, MSA299, etc. I need to run an update script so the MSA part of the string changes to CMA. How can I do this?I have a table (T1) in t-sql with a column (C1)