Hi

I think the answer is that when SQL Server parses your query, it checks that the output of your CASE statement will always be of a consistent data type.

With...