Evaluates to true if the left Name MATCHES 'SQL*05' Evaluates to true if the Name value is operand matches the regular "SQL2005." expression defined by the right operand. IS Evaluates to true if the value ConnectorId IS NULL NULL Evaluates to true if the ConnectorId property of the left operand is null. does not contain a value. Evaluates to true if the value IS NOT ConnectorId IS NOT NULL NULL Evaluates to true if the ConnectorId property of the left operand is not null. contains a value. Evaluates to true if the value Id IN IN of the left operand is in the list of values defined by the right Evaluates to true if the value of the Id property is one of the two globally unique identifiers provided operand. in the expression. Evaluates to true if the left Name = 'SQL%' AND Description LIKE AND 'MyData%' and operands are both true. Evaluates to true if either the Name = 'SQL%' OR Description LIKE OR 'MyData%' left or right operand is true. Evaluates to true if the right NOT (Name = 'IIS' OR Name = 'SQL') NOT operand is not true. Table 3: SDK comparison operators Wildcards The following table defines the wildcard characters you can use to construct a pattern when using the LIKE operator: Wildcard Example Description A wildcard that matches any number of Name LIKE 'SQL%' % characters. Evaluates to true if the Name value is "SQLEngine." Name LIKE '%SQL%'
Evaluates to true if the left operand matches the regular expression defined by the right operand. Name MATCHES 'SQL*05' Evaluates to true if the Name value is "SQL2005." IS NULL Evaluates to true if the value of the left operand is null. ConnectorId IS NULL Evaluates to true if the ConnectorId property does not contain a value. IS NOT NULL Evaluates to true if the value of the left operand is not null. ConnectorId IS NOT NULL Evaluates to true if the ConnectorId property contains a value. IN Evaluates to true if the value of the left operand is in the list of values defined by the right operand. Id IN Evaluates to true if the value of the Id property is one of the two globally unique identifiers provided in the expression. AND Evaluates to true if the left and operands are both true. Name = 'SQL%' AND Description LIKE 'MyData%' OR Evaluates to true if either the left or right operand is true. Name = 'SQL%' OR Description LIKE 'MyData%' NOT Evaluates to true if the right operand is not true. NOT (Name = 'IIS' OR Name = 'SQL') Table 3: SDK comparison operators Wildcards The following table defines the wildcard characters you can use to construct a pattern when using the LIKE operator: Wildcard Description Example % A wildcard that matches any number of characters. Name LIKE 'SQL%' Evaluates to true if the Name value is "SQLEngine." Name LIKE '%SQL%'