Big Data Series

TSQL – Part 1(d) – Working with NULLS

  • NULL is used to indicate an unknown or missing value. NULL is not equivalent to zero or an empty string.
  • Arithmetic or string concatenation operations involving one or more NULL operands return NULL. For example, 12 + NULL = NULL.
  • If you need to compare a value to NULL, use the IS operator instead of the = operator.
  • The ISNULL function returns a specified alternative value for NULL columns and variables.
  • The NULLIF function returns NULL when a column or variable contains a specified value.
  • The COALESCE function returns the first non-NULL value in a specified list of columns or variables).




Additional Reading

Review the documentation for the ISNULL function and Expressions in the Transact-SQL Reference.

Note: Microsoft is the owner of the content and video in this blog post.


2 thoughts on “TSQL – Part 1(d) – Working with NULLS

  1. I am now not certain the place you’re getting your info, but great topic. I needs to spend a while finding out more or figuring out more. Thanks for great info I was in search of this info for my mission.


  2. I am not certain the place you are getting your info, however good topic. I needs to spend some time studying more or figuring out more. Thank you for wonderful information I used to be searching for this information for my mission.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s