4D v12.1

is_null_predicate

Home

 
4D v12.1
4D SQL Reference
Syntax rules
is_null_predicate

 

is_null_predicate  


 

 

Command is_null_predicatarithmetic_expression IS [NOT] NULL

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

 
PROPERTIES 

Product: 4D
Theme: Syntax rules

 
SEE ALSO 

arithmetic_expression
predicate