IF

Keyword IF

Conditional statement.

Syntax:

    IF expression THEN statement1 [ELSE statement2]

See also: CASE

Return one of two values

You can use the MySQL notation

SELECT IF(1>2,2,3);
       -> 3

or the MsSQL notation

SELECT IIF(1>2,2,3);
       -> 3

to get one out of two values.