SQL: Replace word in column data using CTE sql server query

 Hey,

With these query you can easily Replace a word in a string in database..

with cte as(

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

update cte set [Column_name] = cte.NewValueRezult