Abs(Value)

Returns the given numeric expression's absolute, positive value.

Abs(1 - [Discount])

Acos(Value)

Returns a number's arccosine (the angle in radians, whose cosine is the given float expression).

Acos([Value])

Asin(Value)

Returns a number's arcsine (the angle in radians, whose sine is the given float expression).

Asin([Value])

Atn(Value)

Returns a number's arctangent (the angle in radians, whose tangent is the given float expression).

Atn([Value])

Atn2(Value1, Value2)

Returns the angle whose tangent is the quotient of two specified numbers in radians.

Atn2([Value1], [Value2])

BigMul(Value1, Value2)

Returns an Int64 containing the full product of two specified 32-bit numbers.

BigMul([Amount], [Quantity])

Ceiling(Value)

Returns the smallest integer that is greater than or equal to the numeric expression.

Ceiling([Value])

Cos(Value)

Returns the angle's cosine, in radians.

Cos([Value])

Cosh(Value)

Returns the angle's hyperbolic cosine, in radians.

Cosh([Value])

Exp(Value)

Returns the float expression's exponential value.

Exp([Value])

Floor(Value)

Returns the largest integer less than or equal to the numeric expression.

Floor([Value])

Log(Value)

Returns a specified number's natural logarithm.

Log([Value])

Log(Value, Base)

Returns the logarithm of a specified number in a specified Base.

Log([Value], 2)

Log10(Value)

Returns a specified number's base 10 logarithm.

Log10([Value])

Max(Value1, Value2)

Returns the maximum value from the specified values.

Max([Value1], [Value2])

Min(Value1, Value2)

Returns the minimum value from the specified values.

Min([Value1], [Value2])

Power(Value, Power)

Returns a specified number raised to a specified power.

Power([Value], 3)

Rnd()

Returns a random number that is less than 1, but greater than or equal to zero.

Rnd()*100

Round(Value)

Rounds the given value to the nearest integer.

Round([Value])

Round(Value, Precision)

Rounds the given value to the nearest integer, or to a specified number of decimal places.

Round([Value], 2)

Sign(Value)

Returns the positive (+1), zero (0), or negative (-1) sign of the given expression.

Sign([Value])

Sin(Value)

Returns the sine of the angle defined in radians.

Sin([Value])

Sinh(Value)

Returns the hyperbolic sine of the angle defined in radians.

Sinh([Value])

Sqr(Value)

Returns the square root of a given number.

Sqr([Value])

Tan(Value)

Returns the tangent of the angle defined in radians.

Tan([Value])

Tanh(Value)

Returns the hyperbolic tangent of the angle defined in radians.

Tanh([Value])

ToDecimal(Value)

Converts Value to an equivalent decimal number.

ToDecimal([Value])

ToDouble(Value)

Converts Value to an equivalent 64-bit double-precision floating-point number.

ToDouble([Value])

ToFloat(Value)

Converts Value to an equivalent 32-bit single-precision floating-point number.

ToFloat([Value])

ToInt(Value)

Converts Value to an equivalent 32-bit signed integer.

ToInt([Value])

ToLong(Value)

Converts Value to an equivalent 64-bit signed integer.

ToLong([Value])

Ascii(String)

Returns the ASCII code value of the leftmost character in a character expression.

Ascii('a')

Char(Number)

Converts an integerASCIICode to a character.

Char(65) + Char(51)

CharIndex(String1, String2)

Returns the starting position of String1 within String2, beginning from the zero character position to the end of a string.

CharIndex('e', 'devexpress')

CharIndex(String1, String2, StartLocation)

Returns the starting position of String1 within String2, beginning from the StartLocation character position to the end of a string.

CharIndex('e', 'devexpress', 2)

Concat(String1, ... , StringN)

Returns a string value containing the concatenation of the current string with any additional strings.

Concat('A', ')', [ProductName])

Contains(String1, SubString1)

Returns True if SubString1 occurs within String1; otherwise, False is returned.

Contains([ProductName], 'dairy')

EndsWith(String1, SubString1)

Returns True if the end of String1 matches SubString1; otherwise, False is returned.

EndsWith([Description], 'The end.')

Insert(String1, StartPosition, String2)

Inserts String2 into String1 at the position specified by StartPositon

Insert([Name], 0, 'ABC-')

Len(Value)

Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable.

Len([Description])

Lower(String)

Returns String in lowercase.

Lower([ProductName])

PadLeft(String, Length)

Left-aligns the defined string's characters, padding its left side with white space characters up to a specified total length.

PadLeft([Name], 30)

PadLeft(String, Length, Char)

Left-aligns the defined string's characters, padding its left side with the specified Char up to a specified total length.

PadLeft([Name], 30, '<')

PadRight(String, Length)

Right-aligns the defined string’s characters, padding its left side with empty space characters up to a specified total length.

PadRight([Name], 30)

PadRight(String, Length, Char)

Right-aligns the defined string’s characters, padding its left side with the specified Char up to a specified total length.

PadRight([Name], 30, '>')

Remove(String, StartPosition)

Deletes all the characters from this instance, beginning at a specified position.

Remove([Name], 3)

Remove(String, StartPosition, Length)

Deletes a specified number of characters from this instance, beginning at a specified position.

Remove([Name], 0, 3)

Replace(String, SubString2, String3)

Returns a copy of String1, in which SubString2 has been replaced with String3.

Replace([Name], 'The ', '')

Reverse(String)

Reverses the order of elements within String.

Reverse([Name])

StartsWith(String1, SubString1)

Returns True if the beginning of String1 matches SubString1; otherwise, False.

StartsWith([Title], 'The best')

Substring(String, StartPosition, Length)

Retrieves a substring from String. The substring starts at StartPosition and has a specified Length.

Substring([Description], 2, 3)

Substring(String, StartPosition)

Retrieves a substring from String. The substring starts at StartPosition.

Substring([Description], 2)

ToStr(Value)

Returns a string representation of an object.

ToStr([ID])

Trim(String)

Removes all leading and trailing SPACE characters from String.

Trim([ProductName])

Upper(String)

Returns String in uppercase.

Upper([ProductName])

Avg(Value)

Evaluates the average of the values in the collection.

[Products].Avg([UnitPrice])

Count()

Returns the number of objects in a collection.

[Products].Count()

Exists()

Determines whether the object exists in the collection.

[Categories][[CategoryID] == 7].Exists()

Max(Value)

Returns the maximum expression value in a collection.

[Products].Max([UnitPrice])

Min(Value)

Returns the minimum expression value in a collection.

[Products].Min([UnitPrice])

Single()

Returns an object if it is single in a collection.

[Accounts].Single() is not null

Single(Expression)

You can pass an expression as a parameter: [Collection][Condition].Single(Expression). This function returns the Expression if the Collection contains only one object that meets the specified Condition (optional).

[Collection].Single([Property1]) - returns the found object's property value.

Sum(Value)

Returns the sum of all the expression values in the collection.

[Products].Sum([UnitsInStock])

Operator

Description

Example

+

Adds the value of one numeric expression to another or concatenates two strings.

[UnitPrice] + 4

[FirstName] + ' ' + [LastName]

-

Finds the difference between two numbers.

[Price1] - [Price2]

*

Multiplies the value of two expressions.

[Quantity] * [UnitPrice] * (1 - [BonusAmount])

/

Divides the first operand by the second.

[Quantity] / 2

%

Returns the remainder (modulus) obtained by dividing one numeric expression by another.

[Quantity] % 3

|

Performs a bitwise inclusive OR on two numeric expressions. Compares each bit of its first operand to the corresponding bit of its second operand. If either bit is 1, the corresponding resulting bit is set to 1. Otherwise, the corresponding resulting bit is set to 0.

[Number] | [Number]

&

The bitwise AND operator. Compares each bit of its first operand to the corresponding bit of its second operand. If both bits are 1, the corresponding resulting bit is set to 1. Otherwise, the corresponding resulting bit is set to 0.

[Number] & 10

^

Performs a bitwise exclusive OR on two numeric expressions.

[Number] ^ [Number]

==

=

Returns true if both operands have the same value; otherwise, it returns false.

[Quantity] == 10

!=

Returns true if the operands do not have the same value; otherwise, it returns false.

[Country] != 'France'

< 

Less than operator. Used to compare expressions.

[UnitPrice] < 20

<=

Less than or equal to operator. Used to compare expressions.

[UnitPrice] <= 20

>=

Greater than or equal to operator. Used to compare expressions.

[UnitPrice] >= 30

> 

Greater than operator. Used to compare expressions.

[UnitPrice] > 30

In (,,,)

Tests for the existence of a property in an object.

[Country] In ('USA', 'UK', 'Italy')

Between (,)

Specifies a range to test. Returns true if a value is greater than or equal to the first operand and less than or equal to the second operand.

[Quantity] Between (10, 20)

And

&&

Performs a logical conjunction on two Boolean expressions.

[InStock] And ([ExtendedPrice]> 100)

[InStock] && ([ExtendedPrice]> 100)

Or

||

Performs a logical disjunction on two Boolean expressions.

[Country]=='USA' Or [Country]=='UK'

[Country]=='USA' || [Country]=='UK'

~

Performs a bitwise negation on a numeric expression.

~[Roles] = 251

Not

!

Performs a logical negation on a Boolean expression.

Not [InStock]

![InStock]

+

Returns a numeric expression's value (a unary operator).

+[Value] = 10

-

Returns the negative of a numeric expression's value (a unary operator).

-[Value] = 20

Is Null

Returns true if an expression is a null reference, the one that does not refer to any object.

[Region] is null