There are certain operators cannot use with Null operator as result will be null also. Standard comparison operators cannot compare null values because it will return only null, not true or false.

Other available forms of operators are −

  • IS NULL − It gives you result after testing for a NULL value.
  • IS NOT NULL − It gives you confirmation about the unavailability of a NULL value.
  • ISNULL − If it discovery a NULL value it returns a value of 1 if it is absent it returns a value of 0.
  • COALESCE − In case of absence it returns a NULL value but generally, returns the first non-NULL value of a list.
BY Best Interview Question ON 13 Jan 2019