Arithmetic operators allow you to perform calculations.

**expression + expression** Addition. If either expression is NULL, the result is NULL.

**expression - expression** Subtraction. If either expression is NULL, the result is NULL.

**- expression** Negation. If the expression is NULL, the result is NULL.

**expression * expression** Multiplication. If either expression is NULL, the result is NULL.

**expression / expression** Division. If either expression is NULL or if the second expression is 0, the result is NULL.

**expression % expression** 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. If either expression is NULL, the result is NULL.

Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |