• Why is this question about IIF broken because of the case sensitivity issue?

    What real code would ever use varchar(1)?

    Was the extra space in the varchar(4) field supposed to be a trickery?

    Is there a situation where this special notation of a CASE is better?

    Is this feature implemented in a way that we'll later be talking about the price to pay for using this shortcut instead of writing out the case? Of course we shouldn't, but the QotD(s) around "IsNull vs Coalesce" seem to be evergreen... 🙂