Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| 9_wildcards_for_searching [2013/03/18 15:18] – created barbara | 9_wildcards_for_searching [2022/06/01 11:38] (current) – Catherine Riddell | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Wildcards for searching for records ====== | ====== Wildcards for searching for records ====== | ||
| - | {{: | + | ^Key^Action^Example^ |
| + | |% |Find any (or no) characters| **%International** finds all records whose name starts with anything but finishes with International.\\ **International%** finds all records whose name starts with International but finishes with anything.| | ||
| + | |? |Finds a single unknown character | **SM?THJ** finds John Smith, James Smith, John Smyth and Jane Smith.| | ||
| + | |* |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| | ||
| + | |[...]|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.\\ | ||
| + | |||
| + | |||
| + | {{vimeo> | ||
| + | |||
| + | |||
| + | Go back to [[hints_and_tips|Hints, | ||
| - | Go back to [[hints_and_tips|Hints, | ||