ZEROIFNULL Function Example | Teradata Vantage - 17.10 - Example: Testing the Salary Column for Null - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

In this example, you can test the Salary column for null.

   SELECT empno, ZEROIFNULL(salary) 
   FROM employee ; 

A nonzero value is returned for each employee number, indicating that no nulls exist in the Salary column.