Underscore Matches any single character “_” Examples: Matches items with anything in the fourth position “Mar_in” match Martin, Marlin, Markin Hyphen Allows range searches “-“ Examples: Find anything beginning with the letters A or B “A-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. 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 Less than Matches values alphabetically after the criteria “<” Examples: M” Matches anything beginning with letters before the “< letter M in the alphabet. match Adam, Bill, John Would not match Mark. Date Field Searches: Null” Matches anything without a date. “Is Not Null” Matches anything with a date (functions the same as wildcard "*"). “Is Asterisk Matches any dates “*” Examples: Matches any date. “*” Greater than matches dates after the criteria date “>” Examples: 01/01/2002” 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. Greater than or equal to matches dates on or after the criteria date “>=” Examples: anything on or after 1/1/2002 “>= Would match 1/1/2002, 4/1/2002, 1/1/2003, etc. not match 12/31/2001 or before. Note: the space between the equal sign and the date is optional. Less than matches dates before the criteria date “<”
“_” Underscore Matches any single character Examples: “Mar_in” Matches items with anything in the fourth position match Martin, Marlin, Markin “-“ 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. “>” 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 “<” Less than Matches values alphabetically after the criteria Examples: “< M” Matches anything beginning with letters before the letter M in the alphabet. match Adam, Bill, John Would not match Mark. Date Field Searches: “Is Null” Matches anything without a date. “Is Not Null” Matches anything with a date (functions the same as wildcard "*"). “*” Asterisk Matches any dates Examples: “*” Matches any date. “>” Greater than matches dates after the criteria date Examples: “> 01/01/2002” 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. “>=” Greater than or equal to matches dates on or after the criteria date Examples: “>= anything on or after 1/1/2002 Would match 1/1/2002, 4/1/2002, 1/1/2003, etc. not match 12/31/2001 or before. Note: the space between the equal sign and the date is optional. “<” Less than matches dates before the criteria date
Sentinel%20V2%20Module%20Testing%20-%20Week%203.docx