|
|
|
|
|
|
|
|
|
|
version 11
NULLIF (arithmetic_expression, arithmetic_expression)
Description
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);
|
|
|
|
|
|
|
|
|
|