Value

Equal to the value entered.

Type the value you want to find.

Smith finds "Smith".

! value

(exclamation mark)

Not equal to the value entered.

Type an exclamation mark in front of the value you want to exclude.

!Smith finds all values except "Smith".

From-value.. To-value

(double period)

Between the two values entered separated by double periods.

Type the From value, then two periods, and then the To value.

1..10 finds all values from 1 through 10.

However, in a string field A..C finds all values starting with "A" and "B" and values exactly equal to "C" (for example "Ca" will not be found).

To find all values from "A*" through "C*", write A..D.

.. value

(double period)

Less than or equal to the value entered.

Type the two periods and then the value.

..1000 finds any number less than or equal to 1000, for example "100", "999,95", and 1,000.

Value..

(double period)

Greater than or equal to the value entered.

Type the value and then the two periods.

1000.. finds any number greater than or equal to 1000, for example "1,000", "1,000.01", and "1,000,000".

> value

(greater than)

Greater than the value entered.

Type a "greater than" sign and then the value.

>1000 finds any number greater than 1000, for example "1000.01", "20,000", and "1,000,000".

< value

(less than)

Less than the a value entered.

Type a "less than" sign and then the value.

<1000 finds any number less than 1000, for example "999.99", "1", and "-200".

value*

(asterisk)

Starting with the value entered.

Type the starting value and then an asterisk.

S* finds any string starting with S like "Stockholm", "Sydney", and "San Francisco."

* value

(asterisk)

Ending with the value entered.

Type an asterisk and then the ending value.

*east finds any string ending with east like "Northeast" and "Southeast."

* value*

(asterisk)

Contains the value entered.

Type an asterisk, then a value, and then another asterisk.

*th* finds any string containing "th" like "Northeast" and "Southeast."

?

(question mark)

Having one or more unknown characters

Type a question mark at the unknown characters' position in the value.

Sm?th finds "Smith" and "Smyth"

value, value

(comma)

Matching the values entered separated by commas.

Type all your criteria separated by commas.

A, D, F, G finds exactly "A", "D", "F" and "G".

10, 20, 30, 100 finds exactly "10, 20, 30, 100".

( SQL Statement)

(SQL statement between parenthesis)

Matching a defined query

Type a query as an SQL statement between parentheses.

(data source.Fieldname != "A")