Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Working with Databases playlist https://youtube.com/playlist?list=PLNIs-AWhQzclbRVLCZlsFvpz6fz2nPGbt

Get files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/sql-excel-nulls-expressions/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

In this video you'll learn how to work with nulls in your SQL queries. You'll see how to use the IS NULL expression and IsNull function to check for the existence of nulls and how to use the IIf and Switch functions to replace nulls with other values. You'll also see what happens when a null is involved in a calculation and how to make sure that the calculation returns a non-null result.

Chapters
00:00 Topic List
00:42 The Basic Setup
02:34 Testing for Nulls in the WHERE Clause
04:24 Using the IIf Function to Replace Nulls
07:30 Using the IsNull Function
09:23 Replacing Nulls with Different Data Types
11:55 Nulls in Calculations
14:58 Changing the Example Query
16:15 Concatenating Names
17:11 Checking for Null in Text Columns
20:01 Testing for Nulls with the Switch Function
24:49 Calculating the Difference Between Dates
28:05 Replacing Dates using IsNull
30:13 What's Next?

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more