IFNULL

 

The function IFNULL replace NULL values with the replacement value.

SQL Syntax 1:
 
   IFNULL( expression, replacement )
Parameters:
 
  expression
Any expression of any type. This expression is check for NULL.

replacement

The return value if the expression is NULL.

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


100% pure Java DBMS
Mirror Site