Hi All,

Thanks for all the help. Yes it does apear that Sean's suggestion does work. We're still auditing the data but over a first review it appears accurate as intended!!

GilaMonster (3/13/2015)

---

The main thing that immediately comes to mind is that you're missing brackets.

AND takes precedence over OR, meaning without brackets, your WHERE clause actually means

(b.field1 LIKE 'ABC' AND b.field2...

Hi Lowell,

Thanks for responding so fast!!

Yea the data in field3 does have NULL values (in fact most of them are NULL).

The rest of the fields do not have any null...