Loading TOC...
XQuery sql:ifnull

MarkLogic 12 Product Documentation
sql.ifnull

sql.ifnull(
   expr1 as Sequence,
   expr2 as Sequence
) as Sequence

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(null,1) 
=>
1

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