IsNull

Table of Contents

Returns true (1) if the given value is null, otherwise false (0). This is how to test for missing fields and for the unmatched side of an outer join.

Boolean IsNull(String value = null)

Boolean functions return 1 for true and 0 for false. In a WHERE clause compare the result to 1 (or true), for example: WHERE IsLike(Text, 'Cat%') = 1

Selects words that have no matching language.

SELECT w.Text FROM WordList:Word as w OUTER JOIN WordList:Language as l ON l.Id = w.LanguageId WHERE IsNull(l.Name) = 1

Returns null when the conditional is true, otherwise returns the value.

Returns null when the conditional is true, otherwise returns the number.

Returns null when the value equals compareToValue, otherwise returns the value.

Returns null when the number equals compareToValue, otherwise returns the number.

Returns x raised to the power of y.

Returns the given number of characters from the end of the value.

Rounds a number to the given number of decimal places. Midpoint values are rounded to the nearest even number (2.5 rounds to 2).

Scalar functions are evaluated once per row.

Select statements are used to read (or query) data from the database.

Returns the SHA-1 hash of the value's UTF-8 bytes as a lower case hex string.