Loading TOC...

MarkLogic 9 Product Documentation
sql: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

Stack Overflow iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.