Not Equal to query for SQL server

Question

I was trying to execute a query which gets me all the info from Merchant table where PackageID is not equal to 21 or 22 or 23..

Select * from Merchant where PackageID NOT '22' Union Select * from Merchant where PackageID Not '21'

Thanks!!

Answer 1

use PackageID NOT IN (21, 22, 23..)

 Select * from Merchant 
 where PackageID NOT IN (21, 22, 23)

Answer 2

SELECT * FROM Merchant WHERE Packageid NOT IN ('21', '22', '23')