Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

<= (Less Than or Equal To) (SQL Server Compact Edition)

Compares two expressions. When you compare nonnull expressions by using this operator, the result is TRUE when the left operand has a value lower than or equal to the right operand. Otherwise, the result is FALSE.

expression < = expression


Any valid expression in Microsoft SQL Server 2005 Compact Edition. Both expressions must have implicitly convertible data types. The conversion depends on the rules of data type precedence.

The following example uses the less than or equal to comparison operator to find all orders in the Order Details table with quantities equal to or less than 10 units.

SELECT * FROM "Order Details" WHERE Quantity <= '10'
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft