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 […]