And don't forget while you're fixing all the =NULL and <>NULL, you need to also look for this:

CASE <fieldname or expression> WHEN NULL THEN ..... since this is treated as =NULL

Brian