Hi sds,
Please refer sample Query.
SQL
DECLARE @CustomersTable AS TABLE([Id] INT, [Name] VARCHAR(100), [Country] VARCHAR(50))
INSERT INTO @CustomersTable VALUES(1, 'John Hammond', 'USA')
INSERT INTO @CustomersTable VALUES(2, 'Mudassar Khan', 'India')
INSERT INTO @CustomersTable VALUES(3, 'Suzanne Mathews', 'France')
INSERT INTO @CustomersTable VALUES(4, 'Robert Schidner', 'Russia')
DECLARE @CustomersTable2 AS TABLE([ID] INT, [Name] VARCHAR(100), [Country] VARCHAR(50))
INSERT INTO @CustomersTable2
SELECT [Id], [Name], [Country] FROM @CustomersTable
UPDATE @CustomersTable SET [Country] = REPLICATE('X', LEN([Country]))
SELECT * FROM @CustomersTable
SELECT * FROM @CustomersTable2
Screenshot