Service Studio 6.0 Help
Numeric Operators
In Service Studio you have the numeric operators presented below.
Unary minus
Specify negative numbers.
Allowed Data Types
|
- (Unary minus) |
Text |
Integer |
Decimal |
Boolean |
DateTime |
Date |
Time |
|
No |
Yes |
Yes |
No |
No |
No |
No |
Arithmetic operators /, -, *
Common arithmetic operations.
Allowed Data Types
|
/, *, - |
Text |
Integer |
Decimal |
Boolean |
DateTime |
Date |
Time |
|
Text |
No |
No |
No |
No |
No |
No |
No |
|
Integer |
No |
Yes |
Yes |
No |
No |
No |
No |
|
Decimal |
No |
Yes |
Yes |
No |
No |
No |
No |
|
Boolean |
No |
No |
No |
No |
No |
No |
No |
|
DateTime |
No |
No |
No |
No |
No |
No |
No |
|
Date |
No |
No |
No |
No |
No |
No |
No |
|
Time |
No |
No |
No |
No |
No |
No |
No |
Arithmetic operator +
Performs sum operation. When one of the operands is Text, the other operand is cast to Text, and performs the concatenate operation.
Allowed Data Types
|
+ |
Text |
Integer |
Decimal |
Boolean |
DateTime |
Date |
Time |
|
Text |
Yes |
(a) |
(a) |
(a) |
(a) |
(a) |
(a) |
|
Integer |
(a) |
Yes |
Yes |
No |
No |
No |
No |
|
Decimal |
(a) |
Yes |
Yes |
No |
No |
No |
No |
|
Boolean |
(a) |
No |
No |
No |
No |
No |
No |
|
DateTime |
(a) |
No |
No |
No |
No |
No |
No |
|
Date |
(a) |
No |
No |
No |
No |
No |
No |
|
Time |
(a) |
No |
No |
No |
No |
No |
No |
(a) The non-text side is cast to Text and then concatenated.