The following examples show queries on the following table:
CREATE TABLE Membership (FullName CHARACTER(39) ,Age SMALLINT ,Code CHARACTER(4) );
Example: Querying with the ANSI-Compliant Form
Here is the ANSI-compliant form of the Teradata SQL NULLIFZERO(Age) function, and is more versatile.
SELECT FullName, NULLIF (Age,0) FROM Membership;
Example: Blank Spaces
In the following query, blanks indicate no value.
SELECT FullName, NULLIF (Code, ' ') FROM Membership;
Example: Querying for NULLIF in an Expression with an Arithmetic Operator
The following example uses NULLIF in an expression with an arithmetic operator.
SELECT NULLIF(Age,0) * 100;