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.| | ||