Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Common Functions in MS SQL Server

Introduction
The ISNULL() function
The COALESCE() function
The NULLIF() function
Summary
16. Summary

Instruction

Nicely done! Now it's time to review what we've learned:

  • the IS NULL operator checks if the column is NULL,
  • the IS NOT NULL operator checks if the column is not NULL,
  • the ISNULL() function finds NULLs and replaces them with the value given in the second argument,
  • the NULLIF(x, y) function returns NULL if x = y and x otherwise,
  • COALESCE(x, y, ...) returns the first non-NULL argument or replaces a NULL with the value given in the second argument.

Are you ready for a short quiz?

Exercise

Click Next exercise to continue.