Skip to main content

Izenda Operators

Izenda Operators

List of Operators

OperatorDescriptionResult Data TypesExamples
+ (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 CONCATfunction instead.		TextTo 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.NumberPrice after 15% discount:
UnitPrice*0.85
/ (Divide)

expression      /   expression

Numeric/Money / Numeric/Money		Divides one number or currency amount by another.NumberPrice 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.BooleanEmployees 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.BooleanProducts 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.BooleanProducts 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.BooleanProducts still available in stock:
UnitsInStock<>0