* (Multiply) (SQL Server Compact Edition)
Multiplies two expressions.
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 ---------- 168