Is there any difference between IS NULL and =NULL

Viewed 24186

I am surprised to see that IS NULL and =NULL are yielding different results in a select query. What is difference between them? When to use what. I would be glad if you can explain me in detail.

3 Answers
Related