Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision | ||
| 9_wildcards_for_searching [2014/10/08 09:18] – barbara | 9_wildcards_for_searching [2017/12/01 16:35] – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 2: | Line 2: | ||
| ^Key^Action^Example^ | ^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 Internationalbut | + | |% |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 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| | |* |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.\\ **NE1[12]** looks for postcodes NE11 and NE12 because the 4th character must either be a 1 or a 2.\\ This can be very useful for controlled postcode lookup.| | + | |[...]|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.\\ **NE[123][ ]** looks for NE followed by either 1, 2 or 3 as the third character and then a space so NE1, NE2 or NE3 only.\\ **NE1[12]** looks for postcodes NE11 and NE12 because the 4th character must either be a 1 or a 2.\\ This can be very useful for controlled postcode lookup.| |
| Go back to [[hints_and_tips|Hints, | Go back to [[hints_and_tips|Hints, | ||
Catherine Riddell