Searching for missing values

You can search for objects that have null values in the Optiva database.

For example, to search for the formulas that do not have a Calcium parameter:

Select Simple.
Specify CA for the Parameter.
Select the Find Objects Missing These Values? check box.
When you switch to Advanced mode, you can see that the Optiva function, NOTAMEMBER, is added to the syntax.
- Oracle database:
```
NOTAMEMBER(PARAM_CODE = 'CA')
```
- SQL Server database:
```
NOTAMEMBER(PARAM_CODE=N'CA')
```