From ZCubes Wiki
Jump to navigation Jump to search
NVL (Value,Default)


  • 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

Null String

See Also


Empty String