The ISNULL() function
The COALESCE() function
The NULLIF() function
Instruction
Excellent. Keep in mind, though, that the data type of the expression and the data type of the replacement must be the same. For instance, you can't write the following:
SELECT COALESCE(Price, N'unknown') AS Price FROM Product;
The Price column is a decimal data type, but N'unknown' is a string. This will return an error. Instead, you'd need to use a decimal data type value for the NULL replacement.
Exercise
Run the template query. What will happen?
When you're done, click the button.
Stuck? Here's a hint!
No, it's not a typo. This example purposely contains an error.
