DataConnector supports multiple data operations using different operations. The tables below describe following operators with examples:
Arithmetic operators
| Operator |
Description |
Example |
| + (Addition) |
Adds values on either side of the operator |
a + b will give 30 |
| - (Subtraction) |
Subtracts the right hand operand from the left hand operand |
a - b will give -10 |
| * (Multiplication) |
Multiplies values on either side of the operator |
a * b will give 200 |
| / (Division) |
Divides the left hand operand by the right hand operand |
b / a will give 2 |
| % (Modulus) |
Divides the left hand operand by the right hand operand and returns the remainder |
b % a will give 0 |
Comparison operators
| Operator |
Description |
Example |
| = |
Checks if the values of two operands are equal or not, if yes then the condition becomes true. |
(a = b) is not true. |
| != |
Checks if the values of two operands are equal or not, if the values are not equal, then the condition becomes true. |
(a != b) is true. |
| <> |
Checks if the values of two operands are equal or not, if the values are not equal, then the condition becomes true. |
(a <> b) is true. |
| > |
Checks if the values of the left operand is greater than the value of the right operand, if yes then the condition becomes true. |
(a > b) is not true. |
| < |
Checks if the values of the left operand is less than the value of the right operand, if yes then the condition becomes true. |
(a < b) is true. |
| >= |
Checks if the value of the left operand is greater than or equal to the value of the right operand, if yes then the condition becomes true. |
(a >= b) is not true. |
| <= |
Checks if the value of the left operand is less than or equal to the value of the right operand, if yes then the condition becomes true. |
(a <= b) is true. |
Bitwise operators
| Operator |
Description |
Example |
| & |
Binary AND Operator copies a bit to the result, if it exists in both operands. |
(A & B) will give 12 which is 0000 1100 |
| | |
Binary OR Operator copies a bit, if it exists in either operand. |
(A | B) will give 61 which is 0011 1101 |
| ~ |
Binary Ones Complement Operator is unary and has the effect of 'flipping' bits. |
(~A ) will give -61 which is 1100 0011 in 2's complement form due to a signed binary number |
| << |
Binary Left Shift Operator. The left operands value is moved left by the number of bits specified by the right operand. |
A << 2 will give 240 which is 1111 0000 |
| >> |
Binary Right Shift Operator. The left operands value is moved right by the number of bits specified by the right operand. |
A >> 2 will give 15 which is 0000 1111 |
Logical operators
| Operator |
Description |
| AND |
The AND operator allows the existence of multiple conditions in an SQL statement's WHERE clause. |
| OR |
The OR operator is used to combine multiple conditions in an SQL statement's WHERE clause. |
| EXISTS |
The EXISTS operator is used to search for the presence of a row in a specified table that meets certain criteria. |
| IN |
The IN operator is used to compare a value to a list of literal values that have been specified. |
| NOT IN |
The negation of IN operator which is used to compare a value to a list of literal values that have been specified. |
| IS |
The IS operator work like = |
| IS NOT |
The IS operator work like != |
| LIKE |
The LIKE operator is used to compare a value to similar values using wildcard operators. |
| NOT LIKE |
The negation of LIKE operator which is used to compare a value to similar values using wildcard operators. |
| BETWEEN |
The BETWEEN operator is used to search for values that are within a set of values, given the minimum value and the maximum value. |