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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
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.