Using Wildcards in Queries

Wildcards can be used in this application for performing queries. Wildcards are characters that can be used to limit or expand the dataset returned by the query. The wildcards listed below apply to all fields except for memo fields. The only wildcards that apply to memo fields are the * (asterisk) and the ! (exclamation point).

*  Represents any value before or after the asterisk.

     Example: *Delta* would return every record where the word “Delta” appears in the field.

?  Represents any value for a single character in the field.

     Example: John Sm?th would return both “John Smith” and “John Smyth”

>  Returns records where the field value is greater than the entry.

     Example: >5 returns records with a value of 6 and above.

<  Returns records where the field value is less than the entry.

     Example: <5 returns records with a value of 4 and below.

>= Returns records where the field value is greater than or equal to the entry

     Example:>=5 returns records with a value of 5 and above.

<= Returns records where the field value is less than or equal to the entry

     Example: <=5 returns records with a value of 5 and below.

!   Represents the NOT keyword when the first charcter is the exclamation point.

     Example: !Smith returns all records where the field is not equal to “Smith”.

|    Represents the OR keyword.

     Example: MARK|JOE returns all records where the field is equal to “MARK” or “JOE”.

[ ]  If the first character is an open square bracket, records will be returned where the field equals any of the comma delimited values within the brackets.

     Example: [1,2,3,4] Returns records where the field equals 1 or 2 or 3 or 4.

![ ]  If the first character is an exclamation point and the second character is an open square bracket, records will be returned where the field does not equal any of the comma delimited values within the brackets.

     Example: ![1,2,3,4] Returns records where the field is not equal to 1 or 2 or 3 or 4.

:  Represents the BETWEEN keyword and is used for selecting a range of values.

     Example: 1:4 Returns records where the field equals 1 or 2 or 3 or 4.