{"id":1057,"date":"2016-05-26T20:48:29","date_gmt":"2016-05-26T13:48:29","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=1057"},"modified":"2020-04-11T08:58:13","modified_gmt":"2020-04-11T01:58:13","slug":"sqlite-ifnull","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-functions\/sqlite-ifnull\/","title":{"rendered":"SQLite IFNULL"},"content":{"rendered":"\n

The SQLite IFNULL function accepts two arguments and returns the first non-NULL argument. If both arguments are NULL, the IFNULL function returns NULL.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

The following illustrates the syntax of the IFNULL function.<\/p>\n\n\n

IFNULL(parameter_1,parameter_2);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Arguments<\/h2>\n\n\n\n
The IFNULL function has exactly two arguments.<\/p>\n\n\n\n
The IFNULL function is equivalent to the COALESCE<\/a> function with two arguments. Note that the COALESCE function can have more than two arguments.<\/p>\n\n\n\n
Return type<\/h2>\n\n\n\n
The IFNULL function returns the type of the argument or NULL.<\/p>\n\n\n\n
Examples<\/h2>\n\n\n\n
See the following customers<\/code> table in the sample database<\/a>.<\/p>\n\n\n\n
\"customers<\/figure>\n\n\n\n
The following query returns the first name, last name, fax, and phone data of the customers.<\/p>\n\n\n
SELECT<\/span> firstname,\n       lastname,\n       fax,\n       phone\n  FROM<\/span> customers;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Many customers do not have the fax number; in this case, we can use the IFNULL function to return the fax number if it is available or return the phone number if the fax is not available.<\/p>\n\n\n
SELECT<\/span> firstname,\n       lastname,\n       IFNULL<\/span>(fax, 'Call:'<\/span> || phone) fax\n  FROM<\/span> customers\n ORDER<\/span> BY<\/span> firstname;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
\"SQLite<\/figure>\n\n\n\n
See also<\/h2>\n\n\n\n
COALESCE<\/a>, NULLIF<\/a><\/p>\n
\n\t
\n\t\t
Was this tutorial helpful ?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t