Use the OR condition to extract this OR this OR this (either A OR B OR C). The OR condition is communicated by placing multiple test-field-values in one WHERE statement that result in a selection when any one of the acceptable values is found. The structure of a WHERE command having multiple test-field-values is:
Note Only one of the specified conditions within the OR structure must be met for the data to be included in the extraction database. Encyclopedia entries that do not match any of the specified criteria are not included.
Example – OR conditions in WHERE commands
Example 1
This WHERE statement specifies “search the Entity Table for values that are either an entity, or a data store, or a data structure and include the result in the extraction database”.
WHERE Type = Entity, "Data Store", "Data Structure"
Example 2
This WHERE statement specifies “search the Entity Table for description in the definition dialog that start with either Empl, or Emp, or EE and include the result in the extraction database”.
WHERE Description = Empl, Emp, EE
Example 3
Using multiple OR conditions result in a query that searches for this OR this OR this AND that OR that OR that. This WHERE statement specifies “search the Entity Table for values that are either an entity, or a data store, or a data structure AND then search the Entity Table for a description in the definition dialog that starts with either Empl, or Emp, or EE, and include the results in the extraction database”.
WHERE Type = Entity, "Data Store", "Data Structure" WHERE Description = Empl, Emp, EE