IIF()

Return YES if the condition is TRUE, or NO if the condition is FALSE.

SELECT IIF(5<10, '5 is lower than 10', '5 is highest');

Output:
5 is lower than 10