4D v13.4COALESCE |
||||||||||||||
|
4D v13.4
COALESCE
COALESCE
The COALESCE function returns the first non-null expression from the list of arithmetic_expression type arguments passed. It will return NULL if all the expressions passed are NULL. This example returns all the invoice numbers from 2007 where the VAT is greater than 0: SELECT INVOICE_NO |
PROPERTIES
Product: 4D INDEX |
||||||||||||