# Operators in SAP HANA Cloud

Do you want to know about operators in SAP HANA? This is the right article to check various types of operators in SAP HANA Cloud.

Operators are badges or symbol that tell or gives instructions to the system to perform required functions as per the end users either mathematically or logically.

The calculation compares the values between two numbers or two pieces of data and assigns the values done through this function. Let’s get started to see more about operators in SAP HANA.

## Types of Operators in SAP HANA Cloud

There are seven types of operators in SAP HANA to perform their own unique functions. Below are the types.

• Unary and binary operators
• Precedence operator
• Arithmetic operator
• String operator
• Logical operators
• Set operators

## Precedence Operators

In this, we can use more than one operator. This means multiple operators can use in this type. If the required operator is more than one, then SAP HANA analyze them based on operator precedence.

The values expressed with parentheses will be taken as a prior consideration. The different types of operators are described below. SAP HANA estimates operators with equal precedence from left to right.

## Arithmetic Operators

Mathematical operations such as adding, subtracting, multiplying, and dividing numeric values can be done by this arithmetic operator in SAP HANA.

## String Operator

In the SAP HANA, the string operator concatenates or combines two strings, expressions, or constants into one.

## Comparison Operators

Compares the number or thing or strings and performs the estimations. The comparison operator does not return the values as the arithmetic operator does in SAP HANA. It returns either 1 which indicates true or 0 for false.

## Logical Operators

In this cloud version of SAP HANA, the logical operator is used to connect two or more values or expressions. We can also nullify them using the NOT operator.

## SET Operators

The multiple queries are combined to return a single output by set operators. Below are the types of set operators in SAP HANA.

## Conclusion

In this tutorial, we have seen all the types of operators in SAP HANA. Also, we have seen descriptions, syntax, and its uses as well.

• Unary and Binary Operators
• Precedence Operators
• Arithmetic Operators
• String Operators
• Comparison Operators
• Logical Operators
• SET Operators