-- CASE NULL --
CASE WHEN ss.SessionID IS NULL THEN 'No' ELSE 'Yes' END AS IsActive
(CASE WHEN v.[Name] is null then '' else v.[Name] end) as SomeName
-- Example 3:
SELECT g.GraphID,
g.Description,
u.UserGraphID,
CASE WHEN u.GraphTypeID IS NULL AND g.GraphID = 7 THEN 2 ELSE u.GraphTypeID END AS GraphTypeID,
u.IsActive
FROM Graphs g
LEFT JOIN UserGraphs u on (g.GraphID = u.GraphID)
Example 4
SELECT ID,
CASE TypeID
WHEN 0 THEN 1 -- Standard
WHEN 2 THEN 2 -- Enterprise
WHEN 1 THEN 3 -- Premium
ELSE 0 -- Unknown
END AS TheType
FROM Users