Property Filter: string

Description

Sets or retrieves the filter conditions that will be applied to the result set. A number of conditions may be used for the filter, and it is also possible to combine conditions. The use of () signs is allowed to separate conditions. Note that fixed texts must be enclosed with ‘ or " characters.

• <

  Less than.

• >

  Greater than.

• > =

  Greater than or equal to.

• <=

  Less than or equal to.

• =

  Equal to.

• <>

  Not equal to.

• AND

  Tests if both conditions are true.

• NOT

  Tests if the condition is NOT true.

• OR

  Tests if one of the conditions is true.

• +

  Adds numbers or combines text.

• -

  Subtracts numbers.

• *

  Multiplies numbers.

• /

  Divides numbers.

• *

  Wildcard for partial comparison of text; for this PartialKey = TRUE must be specified.

Example

State <>''CA'' or State = BLANK