Defining a filter

The Filter dialog box is used for setting the filter criteria. Filtering lets you reduce the amount of data being loaded. Only the rows that satisfy the filter are loaded. The selections made in the filter are shown with the appropriate syntax in the Filter area on the Table dialog box.

  1. On the Table dialog box, click Filter.
  2. From the list, select the desired operator. Operators test whether the data matches a specified condition. The operator works in conjunction with the To and From boxes that are displayed next to the list. These are the options:
    • Is between
    • Is one of
    • is equal to
    • Is not equal to
    • Is greater than
    • Is greater than or equal to
    • Is less than
    • Is less than or equal to
    • Is like
    • Is not like
    • Is null
    • Is not null
  3. Optionally, select the Case Insensitive option. This option specifies whether case is ignored. Unchecked means that case is considered when returning results. This option is only valid for alphanumeric fields.
  4. Optionally, select the Substring option. This option retrieves a portion of the data. Substring is valid only for alphanumeric fields. If you select the Substring option, you must then set the start position and length.
  5. Start specifies where to start the string. Previous characters are ignored.
  6. Length specifies the number of characters in the string.
  7. Click OK.