This documentation is archived and is not being maintained.

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'