How to perform a Restrict that retrieves null values?

T

Terry Lindeman

The following code is supposed to retrieve all messages where Mileage does
not have the value "done".

Set cNewItems = InFolder.Items.Restrict("[Mileage] <> ""done""")

It retrieves messages with Mileage = "", but not messages with Mileage =
NULL. This seems to be a problem with Exchange moret than POP3. In SQL, I
could just say:

select * from message where mileage <> 'done' or mileage is null

Requesting Mileage = "" will get the blank ones, but not the null ones. Is
there a way to request null values in a Restrict clause?

Terry Lindeman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top