NULLIFZERO Argument Types and Rules - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

A nonnumeric arg is converted to a numeric value, based on implicit type conversion rules. If the argument cannot be converted, an error is reported.See Data Type Conversions.

If arg is a character string, the value is converted to a numeric value of FLOAT data type.

NULLIFZERO cannot be applied to the following types of arguments:
  • BYTE or VARBYTE
  • BLOB or CLOB
  • CHARACTER or VARCHAR if the server character set is GRAPHIC