elasticsearch/docs/reference/esql/functions/predicates.asciidoc

[discrete]
[[esql-predicates]]
=== `IS NULL` and `IS NOT NULL` predicates

For NULL comparison, use the `IS NULL` and `IS NOT NULL` predicates:

[source.merge.styled,esql]
----
include::{esql-specs}/null.csv-spec[tag=is-null]
----
[%header.monospaced.styled,format=dsv,separator=|]
|===
include::{esql-specs}/null.csv-spec[tag=is-null-result]
|===

[source.merge.styled,esql]
----
include::{esql-specs}/null.csv-spec[tag=is-not-null]
----
[%header.monospaced.styled,format=dsv,separator=|]
|===
include::{esql-specs}/null.csv-spec[tag=is-not-null-result]
|===