Operators

Last Updated : Oct 24, 2012 |

There are three types of operators:

  • Arithmetic operators:

    • The ADD operator adds operand1 and operand2.

    • The SUB operator subtracts operand2 from operand1.

    • The MUL operator multiplies operand1 by operand2.

    • The DIV operator divides operand 1 by operand2.

  • String operators:

    • The CATL operator concatenates the operand2 digit string to the left end of operand1.

    • The CATR operator concatenates, or appends, the operand2 digit string to the right end of operand1.

    • The SEL operator selects from operand1 the right-most number of digits specified by operand2.

  • MOD10 validation. The MOD10 operator validates account numbers, membership numbers, credit card numbers, and checks string lengths using the Modulus 10 algorithm. This is also referred to as the Luhn algorithm. MOD10 is a special string operator.