EXCEPT

Joins two tables, and expands vertically. It adds more rows, not columns.

It will remove all identical columns that are selected from the second table.

SELECT Tb1.ColName1,
	Tb1.ColName2,
	Tb1.ColName3,
	Tb1.ColName4
FROM SchemaName.TableName1 AS Tb1
Except
SELECT Tb1.ColName1,
	Tb1.ColName2,
	Tb1.ColName3,
	Tb1.ColName4
FROM SchemaName.TableName1 AS Tb1
	WHERE Tb1.ColName2 = 'You dont want me'