| Symbol / Operator |
Description |
Examples |
| = |
Matches a whole word or matches empty |
- =Market find Market, Market Services and Ongoing Market Research but not Marketing or Supermarket
- = by itself finds all records that have a blank value in that field
- =Chris =Smith finds Chris Smith or Smith Chris but not Chris or Christopher Smithson
|
| = = |
Matches exactly your entered search criteria |
- ==John finds John but not John Smith
- ==John Smith finds John Smith but not Smith, John or John Smithers
|
| ! |
Matches records that have same data within the search field |
- If you only have one person in the database from the state of California and you perform a find using “!” in the state field, the person from California will not show up since there are no duplicate records based on California.
- If you only have 5 people from the city of Santa Clara and 4 people from the city of San Jose, then all of them will be found because they all have duplicates.
|
| < |
Finds all the records that are less than your entered search criteria |
- < Matt finds every person who comes before Matt alphabetically
- <40 finds any record whose value is less than 40
- <4/4/2014 finds any record whose date is less than April 4, 2014
|
≤
<= |
Finds all the records that are less or equal to your entered search criteria |
- ≤ Matt finds every person who comes before Matt alphabetically and includes all Matts as well
- <=95129 finds any record whose value is 95129 or less
- <=05:00:00 finds any record whose value in a time field is 5:00:00 or less
|
| > |
Finds all the records that are greater than your entered search criteria |
- > 9 finds any record whose value is greater than 9
- > 7/30/2014 finds any record whose date is greater than 7/30/2014
|
≥
>= |
Finds all the records that are greater or equal to your entered search criteria |
- ≥ 9 finds any record whose value is greater than 9 including 9
- >= 4/13/2014 finds any record whose date is 4/13/2014 or greater
|
| … |
Finds all the records that are between two values |
- 12:30…17:30 finds all records where the time value is between 12:30 and 17:30
- 1/1/2014…6/6/2014 finds all the records where the date value is between 1/1/2014 and 6/6/2014
- A…M finds all the records where the text value is between A and M
|
| // |
Finds all the records that match based on the date in memory |
- // finds March 21, 2014 when current date is 3/21/2014
|
| ? |
Finds all the records that have an invalid date or time entered into the selected field |
- ? finds twelve but not 12 or twelve30
- ? finds Next Tuesday or 2/33/2014 in a date field
- ? finds midnight in a time field
- To find the ? character search for “?”
|
| @ |
Used as a wildcard character that is part of your search criteria |
|
| # |
Used as a wildcard digit that is part of your search criteria |
- # finds 3 but not 30
- ## finds 30 but not 3 or 300
- #3 finds 53 and 43 but not 3
|
| * |
Used as a wildcard character to find all records based on search criteria plus wildcard |
- Jo*n finds Jon and John
- J*r finds Jr. and Junior
- *phan* finds Phan and Stephanie
- S* finds Sophie, Steve, and Sven
- *”son & Phillips” finds Johnson & Phillips and Paulson & Phillips
- 5/12/* finds the 12th day of May in any year in a date field
- *:15 finds times 15 minutes after any hour in a time field
|
| \ |
Used to search for characters that might otherwise be used as operators or other reserved items |
- \”Joey\” finds “Joey”
- joey\@abc.net finds the email address joey@abc.net
|
| “” |
Used to search for more than one word beginning from the start of the field |
- “Marten and Jones Interiors” finds Marten and Jones Interiors but not James and Marten Interiors”
- “, Ltd” finds all companies with “, Ltd” in the name, but not those without a comma
- “Spring” finds Springville” but not ColdSpring Harbor or HotSpring
- “@” finds @ (or an email address, for example)
- “,” finds records containing a comma
- ” ” finds three spaces in a row
|
| ~ |
Used to search for data / characters that makes the same sound in Japanese |
|
