i am looking for the syntax to be able to include multiple values in a where clause for example.
WHERE InterfacesID != '4016', '3011'
this will throw and error of course the desired result can be achieved using:
Where InterfaceID != '4016' AND InterfaceID != '3011'
however this will be far from optimal if scaled out to a large number to exclude.
WHERE InterfaceID NOT IN (4016,3011)
or perhaps more useful if dynamic need...
WHERE InterfaceID NOT IN (
SELECT InterfeaceID FROM Interfaces where <dynamic WHERE criteria here>