* (Multiplication) (Transact-SQL)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics yesAnalytics Platform System (PDW)

Multiplies two expressions (an arithmetic multiplication operator).

Topic link icon Transact-SQL Syntax Conventions


expression * expression  


To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.


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

Result 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.

-- Uses AdventureWorks  
SELECT ProductID, Name, ListPrice, ListPrice * 1.15 AS NewPrice  
FROM Production.Product  
WHERE Name LIKE 'Mountain-%'  

Examples: Azure Synapse Analytics and Analytics Platform System (PDW)

The following example retrieves the first and last name of employees in the dimEmployee table, and calculates the pay for VacationHours for each..

-- Uses AdventureWorks  
SELECT FirstName, LastName, BaseRate * VacationHours AS VacationPay  
FROM DimEmployee  
ORDER BY lastName ASC;  

See Also

Data Types (Transact-SQL)
Expressions (Transact-SQL)
Built-in Functions (Transact-SQL)
Operators (Transact-SQL)
SELECT (Transact-SQL)
WHERE (Transact-SQL)
*= (Multiplication Assignment) (Transact-SQL)
Compound Operators (Transact-SQL)