nvl

Returns null value.

Available in:

Apps (win) Apps (char) Reportwriter RPC Standalone PL
X X X X X

Syntax

expr nvl(data,null-value)
expr     data,null-value

Description

data specifies the expression to evaluate.

null-value specifies what to return if exp evaluates to NULL.

Example

Prints ``N/A" for null values. 
printf("Salary = " ^^ nvl(SALARY,"N/A"));