Force.com SOQL and SOSL Reference

Salesforce Object Query Language (SOQL)
SOQL Typographical Conventions
Quoted String Escape Sequences
Reserved Characters
SOQL SELECT Syntax
Condition Expression Syntax (WHERE Clause)
null in SOQL Queries
toLabel()
Filtering on Boolean Fields
Querying Multi-Select Picklists
Filtering on Polymorphic Relationship Fields
fieldExpression Syntax
USING SCOPE
ORDER BY
LIMIT
OFFSET
UPDATE TRACKING
UPDATE VIEWSTAT
WITH filteringExpression
GROUP BY
HAVING
TYPEOF
FOR VIEW
FOR REFERENCE
Aggregate Functions
Date Functions
Querying Currency Fields in Multicurrency Organizations
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

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: