Categories
SQL

A Distinct-ly Different Approach to NULL Comparisons

Comparisons involving NULL-able values and columns are an early learning experience. I recently stumbled upon a relatively new way to handle these which I thought would be interesting T-SQL to share. Let’s start with an example, retrieving paid invoices for a particular date: If we pass NULL in to retrieve unpaid invoices we’d change the […]