Logical and Relational Operators

Search criteria can be defined which use comparisons against a specific value. The following examples demonstrate the use of Logic and Relational comparisons:

! (exclamation mark) The ! symbol can be used to find patients who do NOT meet the specified criteria. In other words it is used to invert or negate the logic and is referred to as the NOT operator.
Example:

'!4670' in the Postcode field finds patients who do NOT live within the 4670 postcode area.
< (less than symbol) Use this symbol with numeric data, including dates, to find data that is mathematically less than, but not equal to, the value entered.
Example 1:

'<4670' in the Postcode field finds all postcodes between 0000 and 4669.

Example 2:

'<01/01/1943' in the Date of birth field finds all patients whose birth dates are prior to New Year's Day 1943.
> (greater than symbol) Use this symbol with numeric data, including dates, to find data that is mathematically greater than, but not equal to, the value entered.
Example 1:

'>4670' in the Postcode field finds all postcodes from 4671 onwards.

Example 2:

'>01/01/1943' in the Date of Birth field finds all patients whose birth dates are after New Year's Day 1943.
<= (less than or equal to) This combination finds all numeric data, including dates, that matches, or is less than the value entered.
Example 1:

'<=4670' in the Postcode field finds all postcodes from 0000 to 4670.

Example 2:

'<=14/02/1966' in the Date of Birth field finds all patients born prior to the introduction of decimal currency in Australia.
> = (greater than or equal to) This combination will find all numeric data, including dates, that matches, or is more than the value entered.
Example 1:

'>=4670' in the Postcode field finds all postcodes from 4670 onwards.

Example 2:

'>=01/01/2001' in the Date of Birth field finds all patients born this millennium.