Using SQL NULLIF with Missing Values | Essential SQL

YouTube Excerpt: The NULLIF is a nice short hand way to compare for missing values within columns contains both NULL and blank values. -------------------- This video is part of my Beginner Learning series. If you're interested in learning SQL subscribe to @Essential SQL and then check out our Beginner Learner Playlist. Of course, I also encourage you to visit https:\\www.essentialsql.com to learn even more! ---------------------- Here are the example I used in the video, use them to learn more about NULL IF and play around with it's features: SELECT FirstNAme, MiddleName, LastName FROM Person.Person WHERE NULLIF(MiddleName,'') IS NULL SELECT FirstNAme, MiddleName, LastName FROM Person.Person WHERE case when MiddleName = '' then NULL else MiddleName end IS NULL SELECT FirstNAme, MiddleName, LastName FROM Person.Person WHERE IIF(MiddleName = '',NULL,MiddleName) IS NULL

The NULLIF is a nice short hand way to compare for missing values within columns contains both NULL and blank values. -------------------- This...

Read Full Article 🔍

Curious about Using SQL NULLIF With Missing Values | Essential SQL's Color? Explore detailed estimates, salary breakdowns, and financial insights that reveal the full picture of their profile.

Source ID: CiaRpwMSVP8

Category: color style guide