Replace word in Column Data using DTE Sql server

SQl Query

;with cte as(

select *,(select replace([Column_name],'Old_Value','New_Value')) as NewValueRezult from Table_Name

)

update cte set [Column_name] = cte.NewValueRezult