CASE returns a single data type.
From BOL:
Returns the highest precedence type from the set of types in result_expressions and the optional else_result_expression.
Formatting is best done in the front tool, not in SQL Server itself.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP