OPERATORS

Operators for Text

Operator	Criteria	Explanation
Like	*ist	See Wildcard Characters. If the criterea field is left blank, then all reords will be returned.
Contains	tufted	The field must contain the sequence "tufted" with or without other letters or symbols
=	short-tailed	The field must consist of the string "short-tailed"
Empty		The field must contain no data

Operators for Numbers:

Operator	Criteria	Explanation
=	45	The field must contain the number 45. If the criterea field is left blank, then all reords will be returned.
<	82	The field must contain a number that is less than 82.
>	6020	he field must contain a number that is greater than 6020.
Empty		The field is undefined. No value has been set for it.

Operators for Dates

Operator	Criteria	Explanation
On	06/26/92	The field must contain the date June 26, 1992.
Before	10/01/97	The field must contain a date before October 1, 1997
After	04/30/97	The field must contain a date later than April 30, 1997.
Empty		The field contains no data

Search the Lichen Database

---