T-SQL 101: #28 Working with NULL values (the lack of data) in SQL Server T-SQL queries

added by DotNetKicks
8/21/2019 12:40:12 PM

1 Kicks, 188 Views

Look at the following query: I've asked SQL Server to return orders where there are order comments. I did that by saying: OrderComments IS NOT NULL If I had said IS NULL, I would have returned all the orders with no comments. The interesting concept though, is NULL. What is NULL?