* (Multiplication) (Transact-SQL)

Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW) 👁 Image
SQL analytics endpoint in Microsoft Fabric 👁 Image
Warehouse in Microsoft Fabric 👁 Image
SQL database in Microsoft Fabric

Multiplies two expressions (an arithmetic multiplication operator).

👁 Image
Transact-SQL syntax conventions

Syntax

expression * expression 

Arguments

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.

Result Types

Returns the data type of the argument with the higher precedence. For more information, see Data Type Precedence (Transact-SQL).

Examples

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-%' 
ORDER BY ProductID ASC; 
GO 

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)