Analytics Center Operators

List of Operators

Operator

Description

Result Data Types

Examples

+ (Text Concatenation)

expression      +   expression

Text + Text

Concatenates two text values in that exact order.

Not supported by Oracle and PostgreSQL. In cases where Oracle or PostgreSQL raises an error, please use the CONCAT function instead.

Text

To return employee’s full name from [FirstName] and [LastName] columns:
[FirstName] + ' ' + [LastName]

+ Add

expression      +   expression

Numeric/Money + Numeric/Money

Datetime + Numeric

Numeric + Datetime

Adds two numbers or two currency amount, or adds a number of days to a date.

The data type with the higher prededence.

Two and a half days from hire date:
[HireDate] + 2.5

- (Subtract)

expression      -   expression

Numeric/Money - Numeric/Money

Datetime - Numeric

Subtracts two numbers or two currency amount, or subtracts a number of days from a date.

The data type with the higher prededence.

The number of products in stock after 10 have been taken out:
UnitsInStock - 10

* (Multiply)

expression      *   expression

Numeric/Money * Numeric/Money

Multiplies two numbers, or a currency amount with a number.

Number

Price after 15% discount:
UnitPrice * 0.85

/ (Divide)

expression      /   expression

Numeric/Money / Numeric/Money

Divides one number or currency amount by another.

Number

Price after 50% discount:
UnitPrice / 2

= (Equals)

expression      =   expression

Any data type except Image and Lob.

Compares the equality in value of two expressions. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different.

Boolean

Employees named ‘John’:
[FirstName] = 'John'

> (Greater Than)

expression      >   expression

Any data type except Image and Lob.

Compares if the value of the first expression is higher than the second expression. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different.

Boolean

Products with more than 10 units in stock:
UnitsInStock > 10

< (Less Than)

expression      <   expression

Any data type except Image and Lob.

Compares if the value of the first expression is lower than the second expression. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different.

Boolean

Products with less than 3 units in stock:
UnitsInStock < 3

>= (Greater Than or Equal To)

expression      >=  expression

Any data type except Image and Lob.

Compares if the value of the first expression is higher than or equal to the second expression. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different.

Boolean

<= (Less Than or Equal To)

expression      <=  expression

Any data type except Image and Lob.

Compares if the value of the first expression is lower than or equal to the second expression. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different.

Boolean

<> (Not Equal To)

expression      <>  expression

Any data type except Image and Lob.

Compares if the value of the first expression is not equal to the second expression. The expression of the lower precedence data type is converted to the higher precedence data type in case data types are different. types are different.

Boolean

Products still available in stock:
UnitsInStock <> 0