4D v16

COALESCE

Home

 
Home
4D v16
4D - SQL Reference
Functions
COALESCE

COALESCE  


 

 

Commande COALESCE

COALESCE (arithmetic_expression, ..., arithmetic_expression)

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.

Example  

This example returns all the invoice numbers from 2007 where the VAT is greater than 0:

SELECT INVOICE_NO
FROM INVOICES
WHERE EXTRACT(YEAR(INVOICE_DATE)) = 2007
HAVING (COALESCE(INVOICE_VAT;0) > 0)

Vorige Seite
Nächste Seite

 
EIGENSCHAFTEN 

Produkt: 4D
Thema: Functions

 
GESCHICHTE 

 
ARTIKELVERWENDUNG

4D - SQL Reference ( 4D v16)