create table t1 (col1 varchar(10), col2 varchar(10), col3 varchar(10))

insert into t1 values ('100', 'Prod', 'Ext'), ('101', 'Sales', 'Exd'), ('102', 'Mark', 'Tet'), ('103', 'Purc', 'Ket')

SELECT 
	CASE 
		WHEN col1 = '100' THEN 'col1'
		ELSE col1
	END col1,
	col2,
	CASE 
		WHEN col3 = 'Tet' THEN 'col3'
		ELSE col3
	END col3
FROM t1

INSERT INTO tabledestination SELECT WhatEver FROM table1 WHERE Col1 = 100