Setting Select Properties

Supply a Boolean expression for the Select operator to use to filter rows from the output.

  1. Double-click a Select operator. The Select Properties dialog appears.
  2. (Optional) Edit the Name and Description for this operator.
  3. In the Where field, enter a Boolean expression that defines the selection you want to perform. When this expression evaluates to true for a given row, that row will be included in the output; rows for which this expression evaluates to false will not be included. For example, if you want to list only those employees in your data whose salary (the ANNUAL_SALARY column in the input result set) is $100,000 or less, you might use this expression: ANNUAL_SALARY <= 100000
  4. Click OK to save your changes and close the dialog.
Related concepts
Expressions Menu
Boolean Expressions
Related reference
Properties Dialog Field Descriptions

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com