Any operator that allows two or more expressions to be compared with in a search condition.

Syntax

expression operator expression

Parameters

Remarks

Comparing dates   In comparing dates, < means earlier and > means later.

Comparing LONG VARCHAR or LONG BINARY values   UltraLite does not support comparisons using LONG VARCHAR or LONG BINARY values.

Case-sensitivity   In UltraLite, comparisons are carried out with the same attention to case as the database on which they are operating. By default, UltraLite databases are created as case insensitive.

NOT operator   The NOT operator negates an expression.

See also

• Logical operators
• Search conditions in UltraLite

Example

Either of the following two queries will find all Tee shirts and baseball caps that cost $10 or less. However, note the difference in position between the negative logical operator (NOT) and the negative comparison operator (!>).

SELECT ID, Name, Quantity
FROM Products
WHERE (name = 'Tee Shirt' OR name = 'BaseBall Cap')
AND NOT UnitPrice > 10;

SELECT ID, Name, Quantity
FROM Products
WHERE (name = 'Tee Shirt' OR name = 'BaseBall Cap')
AND UnitPrice !> 10;