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.
Parent topic: Select Operator
Related concepts
Expressions Menu
Boolean Expressions
Related reference
Properties Dialog Field Descriptions

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.