'How to concat a table and then insert the results in the original table

I use the following query:

SELECT 
    [ABCDEF],
    RIGHT(CONCAT('0', [ABCDEF), 6) AS ABCDEFnew
FROM 
    dbo.Table1

Now I would like to return ABCDEFnew into dbo.Table1.

Can somebody help me with that?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source