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