NULL in where statement

Filter records with a NULL value in a specific field.

Overview

The issue arises when trying to isolate records where a particular field, like 'Active', contains a NULL value instead of a standard data entry.
To solve this, modify your query's WHERE clause to explicitly check for NULL using the appropriate syntax for your database system, ensuring it correctly identifies records with no value in the specified field.

jf jformicola 04 Mar, 2020

How do I isolate only those that have a Null in the "Active" field? Thanks!

NULL in where statement image 1

jf jformicola 13 Mar, 2020

can someone help here please?

he healyhatman 14 Mar, 2020

Answer

{value:null}

jf jformicola 16 Mar, 2020

Thank you sir!

This topic is locked and no more replies can be posted.