Export (0) Print
Expand All
Expand Minimize

AND (SQL Server Compact Edition)

Combines two Boolean expressions and returns TRUE when both expressions are TRUE. When more than one logical operator is used in a statement, AND operators are evaluated first. You can change the order of evaluation by using parentheses.


Boolean_expression AND boolean_expression

Boolean_expression

Any valid expression in Microsoft SQL Server 2005 Compact Edition that returns a Boolean value: TRUE, FALSE, or UNKNOWN.

Returns TRUE when both expressions are TRUE.

The following example uses AND to obtain the total cost of a specific order for a particular product.

SELECT UnitPrice * Quantity AS "Total Cost" FROM "Order Details" WHERE ProductID = '11' AND OrderID = '10248'
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft