skip to main content
SQL Statements for Flat-File Drivers : Select Statement : SQL Expressions : Numeric Operators
  
Numeric Operators
You can include the following operators in numeric expressions:
Operator
Meaning
+
Addition
Subtraction
*
Multiplication
/
Division
**
Exponentiation
^
Exponentiation
The following table shows examples of numeric expressions. For these examples, assume salary is 20000.
Example
Resulting value
salary + 10000
30000
salary * 1.1
22000
2 ** 3
8
You can precede numeric expressions with a unary plus (+) or minus (–). For example, –(salary * 1.1) is -22000.