Friday, 15 July 2011

Dealing with null( is null) (is not null) and COALESCE

SELECT CASE
  WHEN Null = NULL THEN 'True'
  ELSE 'False'
  END as '=null'

SELECT CASE
  WHEN Null IS NULL THEN 'True'
  ELSE 'False'
  END as ' IS null'

SELECT FirstName, LastName, Nickname  FROM Customer  WHERE NickName IS NOT NULL ORDER BY LastName, FirstName


select COALESCE(customersince, companyname) from  OBXKites.dbo.Contact where contactcode=106