MarkLogic Server 11.0 Product Documentationsql:ifnull
sql:ifnull( $expr1 as item()*, $expr2 as item()* ) as item()*
Summary
If the first expression is NULL, then the value of the second expression is returned. If not null, the first expression is returned.
| Parameters | |
|---|---|
| expr1 | First expression to be evaluated. |
| expr2 | Second expression to be evaluated. |
Example
sql:ifnull((),1) => 1