Comparison Operators

Comparison operators selected from the middle pop-up list on the Search screen determine how the data entered in the search criteria text box is searched.

Operator	Meaning	Example
Like	Wraps the specified criteria with the wildcard '%' value at the beginning and end	Search criteria ‘tree’ will retrieve ‘trees’ and ‘street’
Not Like	Does not match the specified criteria, wraps the specified criteria with the wildcard '%' value at the beginning and end	Search criteria ‘trees’ will not retrieve ‘trees’ but will retrieve ‘tree’ and ‘street’
=	Searches for an exact match of specified criteria	Search criteria ‘tree’ will retrieve ‘tree’ but will not retrieve ‘Tree’ or ‘street’ or ‘trees’
!=	Does not equal an exact match of specified criteria	Search criteria ‘tree’ will not retrieve ‘tree’ but will retrieve ‘Tree’ and ‘street’ and ‘trees’
>	Greater than the specified criteria	Search criteria ‘20/06/2007’ will retrieve dates ‘21/06/2007’ onwards
<	less than the specified criteria	Search criteria ‘20/06/2007’ will retrieve dates ‘19/06/2007’ and before