Search code examples
sqlansi-sql

Is Coalesce a function of ANSI SQL


Is the COALESCE a function of the ANSI SQL especification? Is it supported by the major relational databases?


Solution

  • Yes:

    https://www.mssqltips.com/sqlservertip/2689/deciding-between-coalesce-and-isnull-in-sql-server/

    From the article:

    Some think that you need to use COALESCE because it is the only one that adheres to the ANSI SQL standard.

    and Yes.