CASE
WHEN BooleanCondition THEN Expression
WHEN BooleanCondition THEN Expression
...
ELSE Expression
END AS Alias
*/
SELECT CustomerTypeName, [Default],
CASE [Default]
WHEN 1 THEN 'default type'
WHEN 0 THEN 'alternate'
ELSE '-'
End as AssignStatus
From dbo.CustomerType