CASE (Transact-SQL)
SQL Server Database Engine returns the else_result_expression if an ELSE clause is specified, ... For a list of control-of-flow methods, see Control-of-Flow Language (Transact-SQL). The CASE statement evaluates its conditions sequentially and stops In ......