1 Reply Latest reply on Aug 7, 2017 11:36 AM by njoylif

    how to include multiple values in WHERE clause

    loftyyy

      i am looking for the syntax to be able to include multiple values in a where clause for example.

       

      SELECT InterfaceID

      FROM Orion.NPM.Interfaces

      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.

       

      many thanks