TODO:
Have you ever wanted to use a CASE statement in a SELECT statement in T-SQL?
SOLUTION:
SELECT Id,
CASE PrimaryColor WHEN NULL THEN
HeaderColor
ELSE
PrimaryColor
END AS HeaderColor
,SectionHeader...
FROM...
WHERE...
NOTES:
This example will evaluate the column 'PrimaryColor'. If it is NULL, then the column 'HeaderColor' will be used. If it does have a value, then 'PrimaryColor' will be used.