:::: MENU ::::

None of the result expressions in a CASE specification can be NULL.

  • Apr 09 / 2009
  • 0
Case Statement, dbDigger, Null Values, T-SQL Interview Questions

None of the result expressions in a CASE specification can be NULL.

The error message
Msg 8133, Level 16, State 1, Line 2
None of the result expressions in a CASE specification can be NULL.
is a run time error message and may be generated at all versions of SQL Srever. The said error message is generated when one result expression in a CASE expression is NULL. To remove the error message, analyze your case statement and modify it to make sure that no expression is NULL.

Consult us to explore the Databases. Contact us