Update a column for all the rows

Question

Table name: Employee
Column Name: Emp_name

Emp_name has this contents:

xx\rama,
xx\rajesh,
xx\vignesh

I have to update the table Employee by removing xx\ from all the rows of column Emp_name.

Please help me.

Answer 1

UPDATE Employee
SET EMP_Name = REPLACE(Emp_name, 'xx\', '')

This will remove all occurences of xx\ in all records.