How to change Some part of Column data as upper using SQL SERVER

How to change Some part of Column data as upper using SQL SERVER


  update Employe set name= Upper(substring(name,0,charindex('(',name)))+ ' '+ SUBSTRING(name, CHARINDEX('(', name) , CHARINDEX(')', name) - CHARINDEX('(', name)+1) where charindex('(',name,0)>0
  update Employe set name= Upper(name) where charindex('(',name,0)=0

The Out put like below