a gist

use-iff-for-tsql-field-expressions.txt

Use IFF for field expressions in TSQL

TSQL, Microsoft's SQL dialect for SQLServer, does not accept simple equations and expressions in place of its fields. 

So this it won't execute:

SELECT NAME='aev-mambro2' as Found FROM USERS; 

Instead, Microsoft wants us to use IIF as a field expression, like so: 

SELECT IIF(NAME='aev-mambro2',1,0) as Found FROM USERS;

Also note that TSQL does not know TRUE and FALSE as constant values. It does not know truthy or falsy expressions or statements. Instead, we must return a 1 (true) or a 0 (false). 

Happy coding!