I need a query that returns data where FieldA is blank AND if (FieldB = 'Special' AND FieldC is null)
So I need all records where FieldA is blank.
In addition I need the records where FieldB is equal to the word "Special" and FieldC, on the same record, is null.
Realize that FieldB can contain other words in which I don't care about the status of FieldC.
I would guess: WHERE FieldA = '' AND (FieldB = 'Special' AND FieldC IS NULL OR FieldB <> 'Special' ).