“IS NOT NULL” and “IS NULL” in CFQL
In CodeFluent Query Language (CFQL), the SQL statement “expression IS NOT NULL” is “expression Exists” and the SQL statement “expression IS NULL” is “NOT expression EXISTS”.
There is no need to write raw SQL to test if a value exists in a method as we sometimes see in models. This can be done in full CFQL thanks to the Exists operator, this way keeping your model as platform independent as possible:
LOAD() WHERE (NOT FirstName EXISTS) AND (LastName EXISTS)
More about CFQL:
The R&D team