Replace simillar words between two string : SQL SERVER

See more:

SQL-Server-2005

SQL-Server

Hello All,

I have one table called as [EmployeeStatus]

and schema as below

EmpID BIGINT
EventDescription NVARCHAR(MAX)

AND Below is the data

EmpID EventDescription
1 Employee Status [PM][AG][OP]
1 Employee Status [PM][AG]

AND I want below output
EmpID EventDescription
1 Employee Status [OP]

Note here I want to remove similar words ([PM] and [AG])

Please let me know how I can achieve this with one select statement


Thanks in advance.