Microsoft KB Archive/202076

= SMS: Query Value Operators for SMS 2.0 =

Article ID: 202076

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q202076



SUMMARY
Systems Management Server (SMS) 2.0 provides Query functionality from the Microsoft Management Console (MMC) SMS Administrator. The WBEM Query language supports the following value operators:


 * IN ([value1], [value2], [value . . .])
 * IN (subselect)
 * BETWEEN ([value1] AND [value2])

For example, t1.SiteCode BETWEEN 'aaa' AND 'ccc'
 * NOT IN ([value1], [value2], [value . . .])
 * NOT IN (subselect)
 * UPPER ([expr])
 * LOWER ([expr])
 * NULL ([expr] is NULL)
 * NOT NULL ([expr] is not NULL)
 * DATEPART ([part], [date 1]) (part = "mm","dd","yy","hour","minute","second","ms") = (equal) < > or != (not equal) < (greater than) > (less than)

