This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:functions:coalesce [2010/07/27 20:43] els |
dev:sql:functions:coalesce [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| The COALESCE function returns the first non-NULL expression among its arguments. | The COALESCE function returns the first non-NULL expression among its arguments. | ||
| - | This function returns the same datatype as the passed parameter. | + | This function returns the same datatype as the passed parameter. If all passed parameters are NULL, then this function returns a NULL. |
| ===== Syntax ===== | ===== Syntax ===== | ||