Table of contents
No headers

Null

Last modified 08:06, 24 Apr 2017
Table of contents
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

Page statistics
525 view(s) and 3 edit(s)
Social share
Share this page?

Tags

CCH Reporter (Smart Reports)

Comments

You must to post a comment.

Attachments

 

 | Cookie Policy | Copyright | Privacy Policy Terms of Use | Contact Us |