Operators:
+
|
Add
|
-
|
Subtract
|
*
|
Multiply
|
/
|
Divide
|
|
|
=
|
Equal
|
!=
|
Not Equal
|
<
|
Less Than
|
<=
|
Less Than or Equal
|
>
|
Greater Than
|
>=
|
Greater Than or Equal
|
|
|
(
|
Left Parenthesis
|
)
|
Right Parenthesis
|
|
|
&&
|
Conditional And
|
AND
|
Conditional And
|
||
|
Conditional Or
|
OR
|
Conditional Or
|
|
|
&
|
Logical And
|
|
|
Logical Or
|
^
|
Logical Xor
|
XOR
|
Logical Xor
|
|
|
%
|
Modulus
|
|
|
<<
|
Shift Left
|
>>
|
Shift Right
|
|
|
[IS] LIKE
|
Like (matches only what is specified)
|
[IS] NOT
|
Negate
|
[IS] BETWEEN
|
Between (range comparison)
|
Functions:
Now
|
Today’s DateTime
|
Date
|
Date portion of DateTime
|
Tod
|
Time of day
|
TimeOfDay
|
Time of day
|
Dow
|
Day of Week
|
DayOfWeek
|
Day of Week
|
Doy
|
Day of Year
|
DayOfYear
|
Day of Year
|
FirstOfMonth
|
First of month (DateTime)
|
EndOfMonth
|
End of month (DateTime)
|
|
|
Year
|
Year
|
Years
|
Year
|
Month
|
Month
|
Months
|
Months
|
Hour
|
Hour
|
Hours
|
Hours
|
Minute
|
Minutes
|
Minutes
|
Minutes
|
Second
|
Second
|
Seconds
|
Seconds
|
|
|
TotalYears
|
Total Years
|
TotalDays
|
Total Days
|
TotalHours
|
Total Hours
|
TotalMinutes
|
Total Minutes
|
TotalSeconds
|
Total Seconds
|
|
|
Ceiling
|
Smallest integral greater than or equal to the value
|
Floor
|
Largest integral greater than or equal to the value
|
Round
|
Rounds to a specified number of digits
|
|
|
Length
|
Length of string
|
|
|
Right
|
Right part of a string with the specified number of characters
|
Left
|
Left part of a string with the specified number of characters
|
Substring
|
Part of a string with the specified number of characters
|
IndexOf
|
Gets the first occurrence of the specified string
|
|
|
Tostring
|
String representation of the specified value
|
Tolower
|
Lowercase representation of the specified string
|
Toupper
|
Uppercase representation of the specified string
|
|
|
Trim
|
Leading and trailing whitespace removed
|
LTrim
|
Leading whitespace removed
|
RTrim
|
Trailing whitespace removed
|
|
|
Raw
|
Unevaluated string contents
|
Examples:
(Client = "Yellow Cross") OR (Client like "Yellow Cross") AND (Items >= 4500)
(Client LIKE "Yellow") AND ("Items" >= 50000)
(Items <= 50000)
(Items IS BETWEEN 1 AND 50000)