Null fields queries

[DDPEN]

I wish to make a query to check for null fields in several
columns of a table. ex. No Zip (or) No Street (or) no
state. What is the most efficient way to do this? Help is
appreciated. dp

 

[Michael Hopwood]

WHERE Zip Is Null OR Street Is Null OR state Is Null