This documentation is archived and is not being maintained.

* (Multiply) (SQL Server Compact Edition)

Multiplies two expressions.

expression * expression


Any valid expression in Microsoft SQL Server 2005 Compact Edition of any of the data types of the numeric data type category, except the datetime data type.

Returns the data type of the argument with the higher precedence.

The following example determines the cost of a customer order by multiplying the quantity ordered by the unit price from the Order Details table.

SELECT UnitPrice * Quantity AS "Total Cost" FROM "Order Details" WHERE ProductID = '11' AND OrderID = '10248'

This is the result set:

Total Cost