Description of Match Criteria

FIELD TYPE	CRITERIA	DESCRIPTION
Character	Equals	Field must exactly equal the value entered.
	Starts With	First characters in the field must match the value entered.
	Contains	Field must contain the value entered.
	Doesn't Equal	Field does not exactly equal the value entered.
	Like	Determines whether or not a given character string matches a specified pattern.
	Null	No entry for that field.
	%	Wild Card (see detail below)
	After	Only fields alphabetically after the value entered will be included.
	Before	Only fields alphabetically before the value entered will be included.
	Between	Requires two values to be entered, e.g., cab and cat. This is best when using numeric or date values.
Numeric	Equals	Field must equal the number entered.
	Not Equal to	Field must not equal the number entered.
	Greater Than	Field must be greater than the number entered.
	Greater Than or Equal	Field must be greater than or equal to the number entered.
	Less Than	Field must be less than the number entered.
	Less Than or Equal	Field must be less than or equal to the number entered.
	Between	Requires two values, e.g., all records between 001 and 009. Report will print records 001, 002, 003, 004, 005, 006, 007, 008, & 009.
Date	Equals	Field must have the same date as the date entered.
	After	Only dates after the entered date will be included.
	On or After	Only dates after or the same as the entered date will be included.
	Before	Only dates before the entered date will be included.
	On or Before	Only dates before or the same as the entered date will be included,
	Between	Requires two date values, e.g., all records between 01/01/2011 and 03/31/2011. This will print all records within the date range specified.
	Blank	Typically used when filtering records for a date value that should not exist, e.g., containers that contain a blank inactive date. This will give you a report with only active containers. This will also filter on all records in the category where a blank field exists which may be helpful for editing purposes.

Like

Determines whether or not a given character string matches a specified pattern. A pattern can include regular characters and wild card characters. During pattern matching, regular characters must exactly match the characters specified in the character string. Wild card characters, however, can be matched with arbitrary fragments of the character string. Using wild card characters makes the LIKE operator more flexible than using the Equals and Not Equal to string comparison operators. If any of the arguments are not of character string data type, Microsoft® SQL Server™ converts them to character string data type, if possible.

Wild Cards

The "%" character is a wild card which is any string of zero or more characters. For example, WHERE title LIKE '%environment%' finds all book titles with the word 'environment' anywhere in the book title.