https://docs.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql?view=sql-server-2017 Simples use case: `SELECT (CASE WHEN (value = 1) THEN 'yes' ELSE 'no' END) AS decision FROM test`
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql?view=sql-server-2017
Simples use case:
SELECT (CASE WHEN (value = 1) THEN 'yes' ELSE 'no' END) AS decision FROM test