### 3. Comparison Expressions

Like SQLite version 2, version 3
features the binary comparison operators '=',
'<', '<=', '>=' and '!=', an operation to test for set
@@ -194,20 +195,22 @@

SQLite may attempt to convert values between the numeric storage
classes (INTEGER and REAL) and TEXT before performing a comparison.
For binary comparisons, this is done in the cases enumerated below.
The term "expression" used in the bullet points below means any
-SQL scalar expression or literal other than a column value.

+SQL scalar expression or literal other than a column value. Note that
+if X and Y.Z are a column names, then +X and +Y.Z are considered
+expressions.
When a column value is compared to the result of an
expression, the affinity of the column is applied to the result of
the expression before the comparison takes place.

When two column values are compared, if one column has
- INTEGER or NUMERIC affinity and the other does not, the NUMERIC
- affinity is applied to any values with storage class TEXT extracted
- from the non-NUMERIC column.

+ INTEGER or REAL or NUMERIC affinity and the other does not,
+ then NUMERIC affinity is applied to any values with storage
+ class TEXT extracted from the non-NUMERIC column.
When the results of two expressions are compared, no
conversions occur. The results are compared as is. If a string
is compared to a number, the number will always be less than the
string.