This shows you the differences between two versions of the page.
dev:sql:functions:coalesce [2010/07/06 18:24] tdo |
dev:sql:functions:coalesce [2016/06/28 22:38] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{page>:top_add&nofooter&noeditbtn}} | ||
- | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
- | ====== Omnidex SQL Function: COALESCE ====== | ||
- | {{page>:sql_bar&nofooter&noeditbtn}} | ||
- | ===== Description ===== | ||
- | |||
- | Returns the first non-NULL expression in the list. The return datatype is the same as the datatype of value. | ||
- | |||
- | ===== Syntax ===== | ||
- | |||
- | COALESCE(value[, value…]) | ||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |