COALESCE

This is the legacy 4D documentation web site. Documentations are progressively being moved to 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 R7

4D SQL Reference

Functions

COALESCE



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

Description

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)

PROPERTIES

Product: 4D
Theme: Functions

PAGE CONTENTS

Description

Example

HISTORY

ARTICLE USAGE

4D SQL Reference ( 4D v20 R7)

Add a comment