is_null.asciidoc 298 B

1234567891011121314151617
  1. [[esql-is_null]]
  2. === `IS_NULL`
  3. Returns a boolean than indicates whether its input is `null`.
  4. [source,esql]
  5. ----
  6. FROM employees
  7. | WHERE IS_NULL(first_name)
  8. ----
  9. Combine this function with `NOT` to filter out any `null` data:
  10. [source,esql]
  11. ----
  12. FROM employees
  13. | WHERE NOT IS_NULL(first_name)
  14. ----