Iif
From How to Use These Six Unusual Sql Functions
Go to text →
IIF
It’s essentially a simpler CASE statement. The IIF() function tests a condition and returns a specified value if the condition is TRUE and another specified value if the condition is FALSE.
in essence it acts like the excel IF function
SELECT
iif(1=1,'TRUE','FALSE') AS 'T'
, iif(1=0,'TRUE','FALSE') AS 'F'
