* (Multiply) (TSQL Operator)

Multiplies two numbers.

Syntax

expression * expression

Arguments

expression

is a numeric expression of type tinyint, smallint, int, bigint, money, numeric, float.

Return Types

Returns the datatype of the expression with the highest type precedence.

Examples

PRINT 123.45 * 30;

-- varchar is converted to int, because int has highest type precedence
PRINT '123' * 50;

The result is:

3703.50
6150