SQL Case Functions

Function	Description
Case	Returns an expression based on a comparison.
Case When	Returns an expression based on a condition being met.
Coalesce	Returns the first non-NULL value from a list of expressions.
NullIf	If values are equal then returns Null.

In This Section