HelpBot ask
Ask Helpbot ask about this page
Copy page
Copy page as Markdown for LLMs
View as Markdown
View this page as plain text
Open in ChatGPT
Ask ChatGPT about this page
Open in Claude
Ask Claude about this page
Connect with MCP
Copy the MCP Server URL
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!