0 out of 1 rated this helpful - Rate this topic

NULL Predicate in Windows SharePoint Services Search SQL Syntax

Windows SharePoint Services 3

Indicates whether the document has a value for the specified column.

Copy


…WHERE <column> IS [NOT] NULL

Remarks

The optional NOT keyword negates the result. The column can be a regular or delimited identifier.

Note:
To test whether a column has the NULL value, you must use the NULL predicate. It is not correct syntax to use the NULL value in a comparison predicate. Correct: `…WHERE column IS NULL` Incorrect: `…WHERE column = NULL`

Note:

To test whether a column has the NULL value, you must use the NULL predicate. It is not correct syntax to use the NULL value in a comparison predicate.

Correct: …WHERE column IS NULL

Incorrect: …WHERE column = NULL

Examples

The following example returns documents that have no author.

Copy

…WHERE Title IS NULL

Other Resources

Non-Full-Text Predicates in Windows SharePoint Services Search SQL Syntax

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ