It's difficult to work out what you are trying to do here - and why you are trying to do it - I suspect you have made some poor choices when you designed your DB. But...
SELECT 'IT' AS [Department Name], DepartmentName AS Department_Match FROM Department
WHERE DepartmentName != 'IT'