James Wondrasek

James is a copywriter and technical writer who lives on the outskirts of Sydney, Australia with his partner, two kids, two cats, and ten chickens. Once upon a time, he was a programmer, but he discovered he would rather write about programming than do it. Although crafting a landing page for a start-up can be fun, what he really loves is writing about difficult subjects in a way that makes them easy to understand.

Back

14 May 2021

James Wondrasek

How to Use Comparison Operators with NULLs in SQL

The SQL NULL value serves a special purpose. It also comes with counterintuitive behaviors that can trip up SQL beginners or even experienced programmers. Learn how to avoid these problems when you use NULL with comparison operators. This article is going to help you master best practices for crafting SQL queries that work with NULL values and use comparison operators ( =, <>, <, > ) – which, if you have written any SQL queries before, you know is just about every query you will ever write!