COALESCE

Dies ist die alte 4D Dokumentations-Website. Die neue und aktualisierte Dokumentation finden Sie unter developer.4d.com

Home

4D - SQL Reference
- Functions
- - SQL Functions
  - ABS
  - ACOS
  - ASCII
  - ASIN
  - ATAN
  - ATAN2
  - AVG
  - BIT_LENGTH
  - CAST
  - CEILING
  - CHAR
  - CHAR_LENGTH
  - COALESCE
  - CONCAT
  - CONCATENATE
  - COS
  - COT
  - COUNT
  - CURDATE
  - CURRENT_DATE
  - CURRENT_TIME
  - CURRENT_TIMESTAMP
  - CURTIME
  - DATABASE_PATH
  - DATE_TO_CHAR
  - DAY
  - DAYNAME
  - DAYOFMONTH
  - DAYOFWEEK
  - DAYOFYEAR
  - DEGREES
  - EXP
  - EXTRACT
  - FLOOR
  - HOUR
  - INSERT
  - LEFT
  - LENGTH
  - LOCATE
  - LOG
  - LOG10
  - LOWER
  - LTRIM
  - MAX
  - MILLISECOND
  - MIN
  - MINUTE
  - MOD
  - MONTH
  - MONTHNAME
  - NULLIF
  - OCTET_LENGTH
  - PI
  - POSITION
  - POWER
  - QUARTER
  - RADIANS
  - RAND
  - REPEAT
  - REPLACE
  - RIGHT
  - ROUND
  - RTRIM
  - SECOND
  - SIGN
  - SIN
  - SPACE
  - SQRT
  - SUBSTRING
  - SUM
  - TAN
  - TRANSLATE
  - TRIM
  - TRUNC
  - TRUNCATE
  - UPPER
  - WEEK
  - YEAR

Home

4D v20

4D - SQL Reference

Functions

COALESCE



	Commande COALESCE COALESCE (arithmetic_expression, ..., arithmetic_expression)

Beschreibung

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

SEITENINHALT

Beschreibung

Example

GESCHICHTE

ARTIKELVERWENDUNG

4D - SQL Reference ( 4D v20)

Fehler melden