Loading TOC...

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.