Adaptive Server uses the following arithmetic operators:
Operator |
Meaning |
|---|---|
+ |
Addition |
– |
Subtraction |
* |
Multiplication |
/ |
Division |
% |
Modulo (Transact-SQL extension) |
Addition, subtraction, division, and multiplication can be used on exact numeric, approximate numeric, and money type columns.
The modulo operator cannot be used on smallmoney, money, float or real columns. Modulo finds the integer remainder after a division involving two whole numbers. For example, 21 % 11 = 10 because 21 divided by 11 equals 1 with a remainder of 10.
When you perform arithmetic operations on mixed datatypes, for example float and int, Adaptive Server follows specific rules for determining the type of the result. For more information, see Chapter 1, “System and User-Defined Datatypes,”
