https://www.tech-recipes.com/blog/2019/06/14/how-to-use-searched-case-expression-in-sql-server/
CASE statement, an expression to evaluate different conditions to return a scalar value. two formats Simple CASE & Searched CASE.
case expressionsql serverusesearchedtech
https://www.tech-recipes.com/blog/2012/09/13/sql-server-use-case-expression-in-update-statement/
The CASE expression is used to compare one expression with a set of expressions in SQL. The result of the CASE expression is a Boolean value, true or false. We...
sql servercase expressionuseupdatestatement