Glossary: SQL Beyond the Basics
IS / IS NOT
Also written: IS DISTINCT FROM, IS NOT
SQLite comparisons that work like = and <> except that two NULLs count as equal, so the result is never unknown. The SQL standard spells it IS DISTINCT FROM.
Glossary: SQL Beyond the Basics
Also written: IS DISTINCT FROM, IS NOT
SQLite comparisons that work like = and <> except that two NULLs count as equal, so the result is never unknown. The SQL standard spells it IS DISTINCT FROM.