I have a Views filter handler, which does $this->query->add_where( $this->options['group'], $this->real_field, vms_get_current_mlid(), $this->operator = ($this->operator == '=') ? 'IN' : 'NOT IN' ); Which initially looks fine, but fails with "NOT IN", when the field value is NULL, as `NOT IN (100)` does not return TRUE for a NULL value, which is what I would like. When the operator is 'NOT IN', I need to add a "OR IS NULL" operator as well. How do I do that?