Text Field Searches:
v “Is Null” Matches anything where the field is blank.
v “Is Not Null” Matches anything where the field is not blank. (Functions the same as wildcard "*")
v “*” Asterisk Matches any characters
Examples:
“Martin*” Matches anything beginning with "Martin"
Would match Martin, Martinez, Martinize, Martini
“Mar*” Matches anything beginning with "Mar"
Would match Marlin, Martin, Martini
“*tin*” Matches anything containing "tin"
Would match Tin, Tines, Augustine, Abtin
“*” Matches anything
v “_” Underscore Matches any single character
Examples:
“Mar_in” Matches items with anything in the fourth position
Would match Martin, Marlin, Markin
v “-“ Hyphen Allows range searches
Examples:
“A-B” Find anything beginning with the letters A or B
Would match Adams, Anderson, Benic, Brown
Note: If you want to look up something that has a
hyphen and shouldn't be treated as a range search,
enter a ~ (tilde) before the hyphen and it will
treat the hyphen as a literal search character.
You can not use other wildcard characters when
searching with the tilde for a literal hyphen.
v “>” Greater than Matches values alphabetically after the criteria
Examples:
“> M” Matches anything beginning with an M and everything
in the alphabet coming after the letter M.
Would match Max, Maxine, Nancy, Paul
v “<” Less than Matches values alphabetically after the criteria
Examples:
“< M” Matches anything beginning with letters before the
letter M in the alphabet.
Would match Adam, Bill, John
Would not match Mark.
Date Field Searches:
v “Is Null” Matches anything without a date.
v “Is Not Null” Matches anything with a date (functions the same as wildcard "*").
v “*” Asterisk Matches any dates
Examples:
“*” Matches any date.
v “>” Greater than matches dates after the criteria date
Examples:
“> 01/01/2002” Finds anything after 1/1/2002
Would match 4/1/2002, 1/1/2003, etc.
Would not match 1/1/2002 or before.
Note: the space between the greater than sign and
the date is optional.
v “>=” Greater than or equal to matches dates on or after the criteria date
Examples:
“>= 01/01/2002” Finds anything on or after 1/1/2002
Would match 1/1/2002, 4/1/2002, 1/1/2003, etc.
Would not match 12/31/2001 or before.
Note: the space between the equal sign and
the date is optional.
v “<” Less than matches dates before the criteria date
Examples:
“< 01/01/2002” Finds anything before 1/1/2002
Would match 1/1/1980, 12/31/2001, etc.
Would not match 1/1/2002 or after.
Note: the space between the less than sign and
the date is optional.
v “<=” Less than or equal to matches dates on or before the criteria date
Examples:
“<= 01/01/2002”
Finds anything on or before 1/1/2002
Would match 1/1/2002, 1/1/1980, 4/1/2001, etc.
Would not match 1/2/2002 or after.
Note: the space between the equal sign and
the date is optional.
v “-“ Hyphen Allows date range searches. These searches are inclusive.
Examples:
“1/1/2001-4/1/2001”
Finds anything on or after 1/1/2001 and on or before
4/1/2001. i.e., 1/1/2001, 2/5/2001, 4/1/2001.
Would not match 12/31/2000 or 4/2/2001
Numeric Field Searches (including money):
v “Is Null” Matches anything without a numeric value.
v “Is Not Null” Matches anything with a numeric value (functions the same as wildcard "*").
v “*” Asterisk Searches are Not Supported for numeric fields. Instead use ">0" or "Is Not Null" when looking for anything with a numeric value.
v “>” Greater than matches values more than the criteria amount
Examples:
> 50 Finds anything greater than 50
Would match 50.01, 51, 60, etc.
Would not match 49.99, 50 or less.
>49.99 Would match 50, 51, 49.9999 (this usually is not a number seen
in Patriot, however).
Would not match 49.99, 35, 49.98
Note: the space between the greater than sign and
the criteria is optional.
v “>=” Greater than or equal to matches values equal to or more than the criteria amount.
Examples:
>= 50 Finds anything equal to or more than 50
Would match 50, 50.00, 51, 60, etc.
Would not match 49.99 or before.
Note: the space between the equal sign and
the criteria is optional.
v “<” Less than matches values less than the criteria amount
Examples:
< 50 Finds anything less than 50
Would match 49.99, 0, 25, -15, etc.
Would not match 50, 50.00 or more.
Note: the space between the less than sign and
the criteria amount is optional.
v “<=” Less than or equal to matches numbers equal to or less than the criteria amount.
Examples:
<= 50 Finds less than or equal to 50
Would match 50, 50.00, 35, etc.
Would not match 50.01 or more.
Note: the space between the equal sign and
the number is optional.
v “-“ Hyphen Allows numeric range searches. These searches are inclusive.
Examples:
50-60 Finds anything equal to or more than 50 and equal to or less
than 60.
Would match 50, 50.01, 55, 59.99, 60.00, etc.
Would not match 49.99, 60.01