TIL – Difference Between isnull() and “is null”

While doing a code review I came across an expression isnull(), In first instance I thought this is a typo and space has been missed, but it passed all the test cases.

So what’s the difference between isnull() and “is null”

is null

is null only checks if the value is null
example - select * from students where name is null


isnull checks if a value is null and also if it contains empty value.

Related Post

Leave a Reply

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