Differences

This shows you the differences between two versions of the page.

--- dev:sql:functions:coalesce [2010/07/02 08:08]
tdo created
+++ dev:sql:functions:coalesce [2016/06/28 22:38] (current)
@@ Line 1: / Line 1: @@
 {{page>:top_add&nofooter&noeditbtn}}
-<html><div align="center"><span style="color:red">DRAFT</span></div></html>
-====== Omnidex SQL Function: CASE ======
 {{page>:sql_bar&nofooter&noeditbtn}}
+====== Omnidex SQL Function: COALESCE ======
 ===== Description =====
+The COALESCE function returns the first non-NULL expression among its arguments.
+This function returns the same datatype as the passed parameter.  If all passed parameters are NULL, then this function returns a NULL.
 ===== Syntax =====
+  COALESCE ( expression [ , expression ... ] )
+== expression ==
+Required.  An expression using SQL language that produces a value.  A scalar expression is generally equivalent to a select item in the SQL SELECT statement, and can be a character expression, numeric expression or date expression.
 ===== Example =====
-==== Example 1 ====
+==== Example 1: COALESCE against columns ====
+<code>
+> select coalesce(name, individual) identifier from individuals;
+IDENTIFIER
+--------------------------------------------------
+MS. MARY LEWIS
+MRS. ALICE R TOLLIVER
+MR. SIDNEY K TOLLIVER
+MRS. JENNIFER J HOPKINS
+MR. CHARLIE HOPKINS
+MS. KIMBERLY BLUE
+KATHLEEN TUCKER
+</code>
+====== Additional Resources ======
+See also:
+{{page>dev:sql:functions:see_also_logic&noheader&nofooter&noeditbtn}}
 {{page>:bottom_add&nofooter&noeditbtn}}
+=====

Back to top

dev/sql/functions/coalesce.1278058105.txt.gz · Last modified: 2016/06/28 22:38 (external edit)

Sitemap Recent Changes