I have say 30 fields and would like to batch check them for NULL in one SQL statement, is there a way? Or do I have to write something like the following for each single field:

select field1 from table1 where isnull(field1);