Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
ug9-9 [2014/03/11 12:32] – barbara | ug9-9 [2017/12/01 16:35] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 19: | Line 19: | ||
|%|Finds all records|%International|Finds all Client records that have something before International in their company name.| | |%|Finds all records|%International|Finds all Client records that have something before International in their company name.| | ||
| | |International%|Finds all Client records that have something after International in their company name.| | | | |International%|Finds all Client records that have something after International in their company name.| | ||
- | |?|Finds a single unknown character.|SM? | + | |?|Finds a single unknown character|SM? |
- | |*|Finds one or more unknown character.|SM*THJ|Finds John Smith, James Smith, John Smyth, Jane Smith, and Jane Smeath.| | + | |*|Finds one or more unknown character(s)|SM*THJ|Finds John Smith, James Smith, John Smyth, Jane Smith, and Jane Smeath.| |
| | | |Enter * on its own to display all the items in the database.| | | | | |Enter * on its own to display all the items in the database.| | ||
|[…]|The area within a set of square brackets represents one character. The database matches anything within the square brackets.|NE1[ ]|looks for postcode NE1 only and not NE11 or NE12 because the 4th character must be a space.| | |[…]|The area within a set of square brackets represents one character. The database matches anything within the square brackets.|NE1[ ]|looks for postcode NE1 only and not NE11 or NE12 because the 4th character must be a space.| |