4D v13.4

NULLIF

Home

 
4D v13.4
NULLIF

NULLIF  


 

 

Command NULLIF

NULLIF (arithmetic_expression, arithmetic_expression)

The NULLIF function returns NULL if the first arithmetic_expression is equal to the second arithmetic_expression. Otherwise, it will return the value of the first arithmetic_expression. The twoexpressions must be comparable.

Example  

This example returns NULL if the total of the invoice is 0:

NULLIF(INVOICE_TOTAL,0);

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands