Force.com SOQL and SOSL Reference

Introduction to SOQL and SOSL
Salesforce Object Query Language (SOQL)
Typographical Conventions in This Document
Quoted String Escape Sequences
Reserved Characters
Alias Notation
SOQL SELECT Syntax
Condition Expression Syntax (WHERE Clause)
Using null in SOQL Queries
Translating Results
Filtering on Boolean Fields
Querying Multi-Select Picklists
Filtering on Polymorphic Relationship Fields
fieldExpression Syntax
USING SCOPE
ORDER BY
LIMIT
OFFSET
Update an Article’s Keyword Tracking with SOQL
Update an Article Viewstat with SOQL
WITH filteringExpression
GROUP BY
HAVING
TYPEOF
FORMAT ()
FOR VIEW
FOR REFERENCE
FOR UPDATE
Aggregate Functions
Date Functions
Querying Currency Fields in Multi-Currency Orgs
Example SELECT Clauses
Relationship Queries
Change the Batch Size in Queries
SOQL Limits on Objects
Syndication Feed SOQL and Mapping Syntax
Location-Based SOQL Queries
Salesforce Object Search Language (SOSL)
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Using null in SOQL Queries

You can search for null values by using the null keyword.

Use null to represent null values in SOQL queries.

For example, the following statement would return the account IDs of all events with a non-null activity date: 
1SELECT AccountId
2FROM Event
3WHERE ActivityDate != null

The WHERE clause behaves in two different ways, depending on the version, when handling null values in a parent field for a relationship query. In a WHERE clause that checks for a value in a parent field, if the parent does not exist, the record is returned in version 13.0 and later but is not returned in versions before 13.0 

1SELECT Id
2FROM Case
3WHERE Contact.LastName = null

Note