Comparison operators

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

Syntax

expression operator expression

Parameters

Operator	Interpretation
=	equal to
>	greater than
<	less than
>=	greater than or equal to
<=	less than or equal to
!=	not equal to
<>	not equal to
!>	not greater than
!<	not less than

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.

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

Discuss this page in DocCommentXchange.

Comparison operators

Syntax

Parameters

Remarks

See also

Example