NotInWithNull.sql

IF (OBJECT_ID('tempdb..#Automobiles') IS NOT NULL)
	DROP TABLE #Automobiles


CREATE TABLE #Automobiles
(
	AutoMake VARCHAR(50) NULL 
	, AutoModel VARCHAR(50) NULL 
	, AutoType VARCHAR(50) NULL 
)


INSERT #Automobiles
VALUES ('Ford', 'Mustang', 'Sedan')
	, ('Datsun', '280Z', 'Coupe')
	, ('Chevrolet', 'Corvette', 'Coupe')
	, ('BMW', 'X5', 'SUV')
	, ('Chevrolet', 'El Camino', NULL)


-- Show cars with a type other than 'Coupe' or NULL. Doesn't work like you might think!
SELECT *
FROM #Automobiles
WHERE AutoType NOT IN ('Coupe', NULL)