Manuals/calci/NVL

NVL (Value,Default)

Description

• The NVL function replaces a NA value or an empty string with a string.
• To evaluate a specified expression and replace a non-NA value or empty string with one value and a NA value with another.
• The specified replacement value when the value of the base value is NA, or the base value when the base value is not NA.
• The data type of the return value is always the same as the data type of the base value.

Related Videos

Describing data with numbers

See Also

• SOME
• REPEATCHAR
• REPLACE

References

[1]

• List of Main Z Functions

• Z3 home