In This Topic

Operators

In This Topic

DataConnector supports multiple data operations using different operations. The tables below describe following operators with examples:

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 |

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. |

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 |

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. The 'EXISTS' operator only works when 'Use Cache=true'. It does not work with 'Use Cache=false' until the related issue is fixed. |

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. |