Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
AND (SQL Server Compact Edition)
Collapse the table of content
Expand the table of content

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'

Community Additions

© 2015 Microsoft