Arithmetic Operators

Arithmetic operators perform mathematical operations within Transact-SQL statements.

These are the arithmetic operators:

Symbol Meaning Can be used with
+ Addition int, smallint, tinyint, numeric, decimal, float, real, money, and smallmoney
- Subtraction int, smallint, tinyint, numeric, decimal, float, real, money, and smallmoney
* Multiplication int, smallint, tinyint, numeric, decimal, float, real, money, and smallmoney
/ Division int, smallint, tinyint, numeric, decimal, float, real, money, and smallmoney
% Modulo* int, smallint, and tinyint
*    A modulo is the integer remainder after a division involving two integers. For
    example, 21 % 9 = 3 because 21 divided by 9 equals 2 with a remainder of 3.