The SQL Server (Transact-SQL) IS NULL condition is used to
test for a NULL value.
expression IS NULL
If expression is a NULL value, the
condition evaluates to TRUE. If expression is not a
NULL value, the condition evaluates to FALSE.
Using - With where clause
So Let say we have multiple
values in last name of employee are null and we want to get the list of those
employee whose last name is null then we can write below query.
SELECT *
FROM employees
WHERE last_name IS NULL;
Expression = null won’t behave like above is null condition
it will return different results.
I am writing a query Select 1 + NULL and it return me NULL instead of zero or 1.
ReplyDeleteCan you please help with the reason ?
Thank you
Roop