Mega Code Archive

 

Categories / MSSQL Tutorial / Query

 

The syntax of the searched CASE function

CASE     WHEN conditional_expression_1 THEN result_expression_1    [WHEN conditional_expression_2 THEN result_expression_2]...    [ELSE else_result_expression] END