Case When - SQL Function

Case When {Condition} Then {ReturnExpression} Else {ElseExpression} End

Case When expressions let you use If...Then...Else logic in SQL Statements.

The database searches for an occurrence of {Condition} that is True, and returns the {ReturnExpression}. If no {Condition} is True, the {ElseExpression} is returned.

Case When function syntax has these named arguments:

Parameter	Description
Condition	Required. The condition to be evaluated.
ReturnExpression	Required. The expression to be returned if Condition is True.
ElseExpression	Required. The expression to be returned if Condition is not True.

For example:

SELECT CustomerCode,
        Case When CreditLimit > 5000
        Then 'High'
        Else 'Low'
        End
FROM ARCUST