Null

Last updated:
    No headers

    Null is a filtering expression that will locate missing or unknown data in a field.

    Examples

    In the following example, entering 'is null'  in the Filter column searches for clients who do not have a date of birth (DOB) attached to them.

     

    In this example, using Postcode in a Field column and then entering any of the Expressions below, displays the results shown.

    Expression

    Result

    Is Null, =Null, = Null

    Displays postcodes with null (blank) values

    Is Not Null, <>Null, <> Null

    Displays postcodes that contain a value