IIF

Table of Contents



Short for "immediate if": returns whenTrue when the condition is true and whenFalse otherwise. The condition is usually one of the boolean functions such as IsEqual or IsGreater.

String IIF(Boolean condition, String whenTrue, String whenFalse)

Conditions

The condition must be a function call. Comparison operators such as 1 = 1 are only supported in WHERE and ON clauses.


round-pushpin Flags the rows where the English text is exactly 'cats'.
SELECT
    English,
    IIF(IsEqual(English, 'cats'), 'YES!', 'no...') as IsCats
FROM
    WordList:FlatTranslate
WHERE
    English LIKE '%cats'

round-pushpin Nests functions in the condition.
SELECT IIF(IsGreater(Length('Hello World'), 10), 'Is True', 'Is False') as Result FROM Single




Home
The home page
SQL :: Abs
Returns the absolute value of a number.
SQL :: Ceil
Returns the smallest whole number that is greater than or equal to the given number.
SQL :: Checksum
Returns a simple 16-bit checksum (0 to 65535) of the value's ASCII bytes. It is fast but not collision resistant; use Sha256 when the value must be unique.
SQL :: Coalesce
Returns the first of the given values that is not null. Accepts any number of values.
SQL :: Concat
Concatenates all of the given values that are not null. Accepts any number of values. The + operator can also be used to concatenate, but a null on either side of + makes the whole result null.
SQL :: DateAdd
Adds offset intervals to a date/time value and returns the new date/time. Use a negative offset to subtract. Interval names are not case-sensitive.
SQL :: DateDiff
Returns the number of intervals between two date/time values (date2 minus date1). See DateAdd for the interval names.
SQL :: DateTime
Returns the server's current local date and time, formatted with the optional .NET date/time format string.
SQL :: DateTimeUTC
Returns the current UTC date and time, formatted with the optional .NET date/time format string. See DateTime for the format specifiers.