IN and NOT IN

Search for properties (NOT) within a certain range.

Example

• SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_ID IN (103,105,106)
• SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_ID NOT IN (105, 106)