Export (0) Print
Expand All
Expand Minimize
0 out of 2 rated this helpful - Rate this topic

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

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'
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.