IFNULL
The function IFNULL replace NULL values with the replacement value.
| SQL Syntax 1: |
IFNULL( expression, replacement ) | |
| Parameters: |
expressionAny expression of any type. This expression is check for NULL. replacement
|
|
| Escape Syntax: |
{fn IFNULL( expression, replacement )} | |
| Return Type: |
The same as the numeric expression. | |
|
|
||
| SQL SYNTAX 2: |
IFNULL( expression ) | |
| Return Type: |
BOOLEAN | |
|
|
||
| Alternative Names: |
ISNULL This is the equivalent from the MS SQL Server. |
Examples:
SELECT ifnull( name , '')
see also:
SQL System Functions
IIF
IS [NOT] NULL