function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jeffstuitjeffstuit 

simple SOQL question - search for null

Here's a simple SOQL question - what's the SOQL syntax for searching for null values? - i.e. what's the equivalent of this SQL:

select * from contact where var1 IS NULL and var2 IS NOT NULL
DevAngelDevAngel
Simple questions deserve simple answers!!

Select * From Contact Where Fax = null

Select * From Contact Where Fax != null

Of course, "Select *" is not supported!