Is there a viable alternative in T-SQL to a nested IF ELSE for comparisons in which different logic must take place based on the result of the comparison? My situation is involves selecting a nvarchar value representing the condition for evaluation, and based on the condition an evaluation takes place. I initially sought to implement this in a CASE statement as follows:Is there a viable alternative in T-SQL to a nes