nvl()

Description:

Get the first non-null and non-empty-string member from a sequence.

Syntax:

A.nvl(x)

 

nvl (x1,…,xn)

Equivalent to A.nvl(), where x1,…,xn are members of sequence A

Note:

The function gets the first non-null and non-empty-string member from sequence A. When parameter x is present, first compute the expression with members of sequence A and then return the eligible member.

Parameter:

A

A sequence

x

An expression; cannot be omitted when A is a table sequence or a record sequence

Return value:

A non-null and non-empty-string member

Example:

When A is a sequence:

 

A

 

1

=[1,2,4].nvl()

1

2

=[null,2,3,4].nvl()

2

3

=[null,"",2,3,4].nvl()

2

4

=nvl(null,"",2,3,4)

2

 

When A is a table sequence or a record sequence:

 

A

 

1

=create(ID,Str).record([1,"",2,,3,"aaa"])

2

=A3.nvl(Str)

Return "aaa"