SELECT CASE – SQL Server Syntax Example: SELECT CASE – T-SQL Example

SELECT CASE – SQL Server Syntax Example: SELECT CASE – T-SQL Example Purpose: – Illustrates the SQL Server syntax for the SELECT CASE CLAUSE . SYNTAX: Simple CASE expression: CASE input_expression WHEN when_expression THEN result_expression [ …n ] [ ELSE else_result_expression ] END Searched CASE expression: CASE WHEN Boolean_expression THEN result_expression... [Read More...]