3 Valued Logic

Most programming languages treat NULL as a known value, separate from True and False. SQL does not play by the same rules