Numeric Operators
- Last Updated: October 5, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
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.