Tag: case expression

CASE EXPRESSION
T-SQL supports an expression called CASE. Statement performs some kind of an action or controls flow of the code. CASE returns a value or an expression.
CASE expression has two forms:
Simple form
Searched form
SQL supports many functions that can be considered as abbreviates of the CASE