2,155
edits
Changes
→Relational Expressions
* '''Equal (==)''': Performs the equal comparison expression between two operands. Represented by the equal operator (==). The expression syntax is ''<expression> == <expression>''. '''Examples''': "Unit Price" == "Total Price";
* '''Different (!=)''': Performs the different comparison expression between two operands. Represented by the different operator (!=). The expression syntax is ''<expression> != <expression>''. '''Examples''': "City.City" != 'New York';
* '''Greater than (>)''': Return ''true'' if the the first expression is greater than the second expression and ''false'' otherwise. Represented by the greater operator (>). The expression syntax is ''<expression> > <expression>''. '''Examples''': "Order Date" > '01/01/2011';
* '''Greater or equal than (>=)''': Return ''true'' if the the first expression is greater than or equal to the second expression and ''false'' otherwise. Represented by the greater or equal operator (>=). The expression syntax is ''<expression> >= <expression>''. '''Examples''': IF("Order Date" >= '01/01/2011';"Order Date";0);
* '''Lesser than (<)''': Return ''true'' if the the first expression is lesser than the second expression and ''false'' otherwise. Represented by the lesser operator (<). The expression syntax is ''<expression> < <expression>''. Examples: "Profit" < '0'; * '''Lesser or equal than (<=)''': Return ''true'Examples' if the the first expression is lesser than or equal to the second expression and ''false'' otherwise. Represented by the lesser or equal operator (<=). The expression syntax is ''<expression> <= <expression>''. Examples: IF("Order DateProfit" <= '01/01/20110';"Order Date";0).
* '''Lesser or equal than (<=)''': Return ''true'' if the the first expression is lesser than or equal to the second expression and ''false'' otherwise. Represented by the lesser or equal operator (<=). The expression syntax is ''<expression> <= <expression>''. '''Examples''': IF("Order Date" <= '01/01/2011';"Order Date";0).
=== Logical Expressions ===