Functions
COALESCE
| Syntax |
COALESCE(exp1,exp2,...exp(n)) |
| Description |
Returns the first non-NULL expression among its arguments or NULL if all its arguments are NULL. |
| Example |
COALESCE(3+NULL, 2*NULL, 5*2*7) |
IF
| Syntax |
IF(expression, true_part, false_part) |
| Description |
Returns either the true part or the false part, depending on the evaluation of the expression. |
| Example |
IF([CustomerID]='VINET' AND [OrderID]='10248', [Discount], [Discount]+0.1) |
ELSE IF
| Syntax |
IF(expression,1,IF(expression,0,1)) |
| Description |
Returns either the true part or the evaluated if expression in the false part, depending on the evaluation of the expression. |
| Example |
IF([id] >5,1,IF([id] <5,0,1)) |
IFNULL
| Syntax |
IFNULL(expression1, expression2) |
| Description |
Returns expression1 if the expression1 evaluates to be not null. |
| Example |
IFNULL([ShipRegion],'Region not specified') |
ISNOTNULL
| Syntax |
ISNOTNULL(expression) |
| Description |
Returns true if the given expression evaluates to be not null. |
| Example |
ISNOTNULL([ShipRegion]) |
ISNULL
| Syntax |
ISNULL(expression) |
| Description |
Returns true if the given expression evaluates to null. |
| Example |
ISNULL([ShipRegion]) |
Thank you for your feedback and comments.We will rectify this as soon as possible!