Find Operand Constants (SQLDMO_FIND_OPERAND)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Find operand constants are used by SQL Distributed Management Objects (SQL-DMO) objects that apply filter criteria. Use find operand constants to specify comparison for operations that enumerate Microsoft SQL Server components.

Properties using find operand constants to specify a comparison behavior are always associated with at least one other property through which a value is specified. For example, the DateFindOperand property of the JobFilter object modifies interpretation of a date value specified by the DateJobCreated property.

Constant

Value

Description

SQLDMOFindOperand_EqualTo

1

Default. Return values are equal to the user-defined, qualifying value.

SQLDMOFindOperand_GreaterThan

2

Return values are greater than the user-defined, qualifying value.

SQLDMOFindOperand_LessThan

3

Return values are less than the user-defined, qualifying value.

SQLDMOFindOperand_Unknown

0

Does not apply filtering on comparison against the associated property.