NOT_DISPLAYS_AS

All functions > COMPARISON > NOT_DISPLAYS_AS

Returns TRUE if two values are distinct, treating NULL values as comparable.

Syntax

NOT_DISPLAYS_AS(expr1, expr2)
sql

Arguments

ParameterTypeRequiredDescription
value1BIGINTYesFirst value to compare
value2BIGINTYesSecond value to compare

Returns

BOOLEAN - TRUE if values are distinct, FALSE otherwise

Notes

  • Unlike regular inequality (!=), this function treats NULL values as comparable
  • NULL NOT_DISPLAYS_AS NULL returns FALSE (they are not distinct)
  • value NOT_DISPLAYS_AS NULL returns TRUE if value is not NULL
  • NULL NOT_DISPLAYS_AS value returns TRUE if value is not NULL
  • Both values must be of the same type
  • Standard SQL alias: IS_DISTINCT_FROM
  • Can be used with operator syntax: value1 IS DISTINCT FROM value2

Aliases

  • IS_DISTINCT_FROM

See also

Examples

Basic comparisons

NULL handling

Other types

Suggest changes to this page
Last update at: 2025/10/13 10:23:46