Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite SQL reference » UltraLite SQL language elements » Operators in UltraLite

 

Arithmetic operators

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.

 See also