Case contains items download the new version

input_expression is any valid expression. The expression evaluated when the simple CASE format is used. To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.

WHEN Boolean_expression THEN result_expression WHEN when_expression THEN result_expression Syntax for SQL Server, Azure SQL Database and Azure Synapse Analytics. For example, you can use CASE in statements such as SELECT, UPDATE, DELETE and SET, and in clauses such as, IN, WHERE, ORDER BY, and HAVING.

The searched CASE expression evaluates a set of Boolean expressions to determine the result.īoth formats support an optional ELSE argument.ĬASE can be used in any statement or clause that allows a valid expression. The simple CASE expression compares an expression to a set of simple expressions to determine the result. Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft FabricĮvaluates a list of conditions and returns one of multiple possible result expressions.

Case contains items download the new version