SQL Server IIF() Function - W3Schools
https://www.w3schools.com/sqL/func_sqlserver_iif.asp
WEBDefinition and Usage. The IIF () function returns a value if a condition is TRUE, or another value if a condition is FALSE. Syntax. IIF ( condition, value_if_true, value_if_false) Parameter Values. Technical Details. More Examples. Example. Return 5 if the condition is TRUE, or 10 if the condition is FALSE: SELECT IIF (500<1000, 5, 10);
DA: 72 PA: 61 MOZ Rank: 26