DISPLAYS_AS

All functions > COMPARISON > DISPLAYS_AS

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

Syntax

DISPLAYS_AS(expr1, expr2)
sql

Arguments

ParameterTypeRequiredDescription
value1BIGINTYesFirst value to compare
value2BIGINTYesSecond value to compare

Returns

BOOLEAN - TRUE if values are not distinct, FALSE otherwise

Notes

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

Aliases

  • IS_NOT_DISTINCT_FROM

See also

Examples

Basic comparisons

NULL handling

Other types

Suggest changes to this page
Last update at: 2025/11/06 07:00:15
Last updated: 2025-11-06 07:00:51