Sql case when multiple conditions

Applies to:SQL ServerAzure SQL DatabaseAzure SQL Managed InstanceAzure Synapse AnalyticsAnalytics Platform System (PDW)SQL analytics endpoint in Microsoft FabricWarehouse in Microsoft FabricSQL database in Microsoft Fabric

Evaluates a list of conditions and returns one of multiple possible result expressions.

The expression has two formats:

• The simple expression compares an expression to a set of simple expressions to determine the result.

• The searched expression evaluates a set of Boolean expressions to determine the result.

Both formats support an optional ELSE argument.

can be used in any statement or clause that allows a valid expression.

For example, you can use in statements such as SELECT, UPDATE, DELETE and SET, and in clauses such as <select_list>, IN, WHERE, ORDER BY, and HAVING.

Transact-SQL syntax conventions

Syntax

Syntax for SQL Server, Azure SQL Database and Azure Synapse Analytics.

Syntax for Parallel Data Warehouse.

Arguments

input_expression

The expression evaluated when the simple format is used.

input_expres