SQL Server’s three-valued logic is a concept that extends the traditional two-valued logic to include a third value, known as NULL. Three-valued logic is used to handle cases where the value of a column in a database table is unknown or not applicable. Get to grips with this complex idea.