11.1.5 Using Wildcards to make Query
You need not always specify the criteria for a query. You can use wild cards such as:
| Wild Card | Description | Implication |
|---|---|---|
| - | Underscore | To match a single character |
| % | Percent | To match any string of multiple characters |
Using %
For instance, if you have to check the messages relating to one particular Loans product LD01, you can query for records with Reference Number like ‘%LD01%’ since all the contract reference numbers with that product will invariably contain that string.
Once you click the Accept button and make a query, the ‘Outgoing Message Browser’ screen displays all the Free Format Texts.
Using And
When you are searching for strings of specific length which vary in only one character – for instance, all branches like 001, 002, 003 – can be represented as 00_. Searching for 00_ will fetch all the messages for all these three branches.
Parent topic: Advanced Search