Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

* (Multiply) (Transact-SQL)

Multiplies two expressions (an arithmetic multiplication operator).

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.

Topic link icon Transact-SQL Syntax Conventions

expression * expression


Is any valid expression of any one of the data types of the numeric data type category, except the datetime and smalldatetime data types.

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 AdventureWorks2012;
SELECT ProductID, Name, ListPrice, ListPrice * 1.15 AS NewPrice
FROM Production.Product
WHERE Name LIKE 'Mountain-%'

Community Additions

© 2015 Microsoft