Comparisons that return TRUE  Using “NULL” as a character string

Chapter 4: Expressions, Identifiers, and Wildcard Characters

Difference between FALSE and UNKNOWN

Although neither FALSE nor UNKNOWN returns values, there is an important logical difference between FALSE and UNKNOWN, because the opposite of false (“not false”) is true. For example, “1 = 2” evaluates to false and its opposite, “1 != 2”, evaluates to true. But “not unknown” is still unknown. If null values are included in a comparison, you cannot negate the expression to get the opposite set of rows or the opposite truth value.





Copyright © 2005. Sybase Inc. All rights reserved. Using “NULL” as a character string

View this book as PDF