4D Doc Center : is_null

Home

4D v14

is_null_predicate



	Command is_null_predicatarithmetic_expression IS [NOT] NULL

Description

An is_null_predicate is used to find an arithmetic_expression with a NULL value. You can also pass the NOT keyword to find those without NULL values.

Example

This example selects products whose weight is less than 15 or whose Color column contains a NULL value:

SELECT Name, Weight, Color
FROM PRODUCTS
WHERE Weight < 15.00 OR Color IS NULL