Which comparison operators can be used when searching for null values? Which comparison operators cannot be used when searching for null values?

QUESTION:

Which comparison operators can be used when searching for null values? Which comparison operators cannot be used when searching for null values? What is the result when these unacceptable comparison operators are used when searching for null values?

 

[signinlocker]

SOLUTION

 

None of the comparison operators except for IS NULL or IS NOT NULL can be used when searching for null values.

[/signinlocker]

Leave a Reply

Your email address will not be published. Required fields are marked *