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 results

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


round-pushpin 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