NULL Predicate in Windows SharePoint Services Search SQL Syntax

Question

At http://msdn.microsoft.com/en-us/library/ms472953.aspx is stated that queries like

WHERE column IS NULL

and

WHERE column IS NOT NULL

are allowed. IS NOT NULL is working. IS NULL does not return any items. I think this is because the SharePoint indexer does not include null values in the Index. But this syntax is documented at MSDN.

Does anybody know how to use the IS NULL predicate correctly?

Answer 1

I don't think there is, see this blog post for more info.

Answer 2

I'm looking for a resolution to the same issue but unfortunately could not find any.

I'm planning to run 2 search queries, one a normal query (Set A) and other a "IS NOT NULL" query (Set B) and return A minus B as result set. Let me know if you have a better idea