Using CLogFilter Class

A filter can specify that a field should have a specific value and also that it should have a NULL value. For example, it is possible to call CLogFilter::SetNumber() and CLogFilter::SetNullFields(ELogNumberField).

Although this appears contradictory, the resulting SQL statement simply ORs the conditions so that the WHERE clause contains (Number = 123 Or Contact IS NULL).