+ 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!