Which of the following criteria selects records for customers except those who live in New York,even if the City field is blank?
A) Null OR Not "New York"
B) Is Not Null OR "New York"
C) Not "New York"
D) Is Null OR Not "New York"

Question

Quizplus · Accepted Answer

The correct choice is "Is Null OR Not 'New York'" because it includes records where the City field is either blank (Is Null) or contains a value that is not "New York". This ensures that customers from all locations except New York are selected, including those with an unspecified city.

Which of the Following Criteria Selects Records for Customers Except