I have changed three columns by using a replace command in sql server with following query

```
select name ,replace (name,'...','.') as names from dbo.emp_2 where name like '%..%'

```

After replacing the replaced values has been entered in a new row .

Now i just wants to update the replaced values into original table . SO, I was thinking to use select query in the update query .

Is that possible , Is it so kindly provide a sample query for that