* (Multiply) (Transact-SQL)

Multiplies two expressions (an arithmetic multiplication operator).

Topic link iconTransact-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.

USE AdventureWorks;
GO
SELECT ProductID, Name, ListPrice, ListPrice * 1.15 AS NewPrice
FROM Production.Product
WHERE Name LIKE 'Mountain-%'
ORDER BY ProductID ASC;
GO

See Also

Reference

Data Types (Transact-SQL)
Expressions (Transact-SQL)
Functions (Transact-SQL)
Operators (Transact-SQL)
SELECT (Transact-SQL)
WHERE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance