operators-functions.md

Math Operators

• Add : +
• Subtract : -
• Multiply : *
• Divide : /
• Remainder : %
• Exponent : ^
• Square Root : |/
• Absolute value : @

Comparisons

• Equal: =
• Greater than: >
• less than: <
• Greater than equal: >=
• Less than equal: <=
• Not equal to
  • <>
  • !=
• is present in the list: IN
• is not present in the list: NOT IN
• between two values (bounds are inclusive): BETWEEN

String Operators / Functions

• Join two strings
  • ||
  • CONCAT()
• Convert to lower case string : LOWER()
• Convert to upper case string : UPPER()
• Length of the string : LENGTH()
• greatest: GREATEST()
• least: LEAST()