When using search in the Parameters dialog, you have the following options how to define the search criteria:
|
Search For |
How to Search |
Example |
|
Single keyword |
Type the desired word. |
d12 |
|
Multiple keywords |
Type multiple keywords separated by spaces. |
d12 d13 |
|
An exact match of a phrase |
Put the phrase in quotes. |
"distance" |
|
Search in a specific column only Note: You can enter incomplete column names. The search results are shown for the first column whose name matches the entered string
|
Enter a column name before a keyword followed by a colon (without space). Note: If the column name has multiple words, use quotation marks for the column name.
|
Equation:deg "Model Value": 120 |
|
Include special symbols in a query |
To include quotation marks, brackets or keyword modifiers in a query, put the query in single or double quotes. |
'Mate:1' "d22 + d37 |
Options and Modifiers
You can enable one of the following operators used to compare words in records with keywords in a query:
|
Operator |
Description |
|
Contains |
Searches for words that contain keywords. |
|
StartsWith |
Searches for words that start with keywords. |
|
Like |
Searches for words that match a pattern. Use the % wildcard to replace one or multiple characters. |
|
Equals |
Searches for words that equal keywords in the query. |
You can override the specified comparison operator for a particular keyword using modifiers.
|
Modifier |
Operator |
|
* |
Contains use this modifier to search for words that start with keywords, but a particular keyword doesn't have to be in the beginning. |
|
^ |
StartsWithuse this modifier to search for words that contain keywords, but a particular keyword doesn't have to be in the beginning. |
|
~ |
Like. |
|
= |
Equals. |
You can override the specified mode for a particular keyword using the following modifiers:
|
Modifier |
What It Does |
|
? |
Optional keyword. Use this modifier if results should contain all keywords, but a particular keyword is optional. |
|
+ |
Mandatory keyword. Use this modifier if results should contain any of the keywords, but a particular keyword is mandatory. |
|
- |
Exclude keyword. |