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.

Examples

Related Videos

Null String

See Also


References

Empty String