* (Multiply) (Transact-SQL)
Multiplies two expressions (an arithmetic multiplication operator).
Returns the data type of the argument with the higher precedence. For more information, see Data Type Precedence (Transact-SQL).
The following example retrieves the product identification number, name, the list price and the new list price of all the mountain bicycles in the Product table. The new list price is calculated by using the * arithmetic operator to multiply ListPrice by 1.15.
USE AdventureWorks2008R2; GO SELECT ProductID, Name, ListPrice, ListPrice * 1.15 AS NewPrice FROM Production.Product WHERE Name LIKE 'Mountain-%' ORDER BY ProductID ASC; GO