Handle NULLs - Training
learn.microsoft.com/en-us/training/modules/introduction-to-transact-sql/5b-handle-nulls
1 Users
0 Comments
5 Highlights
0 Notes
Tags
Top Highlights
A NULL value can be used for values that haven’t been supplied yet, for example, when a customer has not yet supplied an email address.
The value substituted for NULL must be the same datatype as the expression being evaluated.
In the above example, MiddleName is a varchar, so the replacement value could not be numeric.
In addition, you'll need to choose a value that will not appear in the data as a regular value.
The NULLIF function allows you to return NULL under certain conditions.
Ready to highlight and find good content?
Glasp is a social web highlighter that people can highlight and organize quotes and thoughts from the web, and access other like-minded people’s learning.