Export (0) Print
Expand All
Expand Minimize

AND (SQL Server Compact)

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 SQL Server Compact 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 [Unit Price] * Quantity AS "Total Cost" FROM "Order Details" WHERE [Product ID] = '11' AND [Order ID] = '10248'
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft