{"id":268,"date":"2024-08-23T02:25:45","date_gmt":"2024-08-23T02:25:45","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=268"},"modified":"2025-05-16T06:24:40","modified_gmt":"2025-05-16T06:24:40","slug":"sql-null-functions","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/sql-null-functions\/","title":{"rendered":"SQL Null Functions"},"content":{"rendered":"\n<p>In SQL, NULL represents missing or unknown data. When dealing with NULL values, it is often important to replace them with more meaningful data. SQL provides several functions to handle NULL values across different databases. The most common ones are IFNULL (), ISNULL (), COALESCE (), and NVL ().<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Null Functions Syntax<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">SQL IFNULL(), ISNULL(), COALESCE(), and NVL() Functions<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><code>IFNULL(expression, replacement_value)<\/code><\/strong> \u2013 Replaces <code>NULL<\/code> with a specified replacement value.<\/li>\n\n\n\n<li><strong><code>ISNULL(expression, replacement_value)<\/code><\/strong> \u2013 Similar to <code>IFNULL()<\/code>, but specific to SQL Server.<\/li>\n\n\n\n<li><strong><code>COALESCE(expression1, expression2, ..., expressionN)<\/code><\/strong> \u2013 Returns the first non-<code>NULL<\/code> value in a list of expressions.<\/li>\n\n\n\n<li><strong><code>NVL(expression, replacement_value)<\/code><\/strong> \u2013 Replaces <code>NULL<\/code> with a replacement value, specific to Oracle databases.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Null Functions Example Solutions<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Null Functions Using<code> IFNULL()<\/code> Example<\/h3>\n\n\n\n<p>This query checks for null values in the last_name column of the Patients table and replaces them with &#8216;Unknown&#8217;<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:false,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;default&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SELECT patient_id, IFNULL(last_name, 'Unknown') AS last_name\nFROM Patients;<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"322\" src=\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png\" alt=\"\" class=\"wp-image-1038\" style=\"width:925px;height:auto\" srcset=\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png 1024w, https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1-300x94.png 300w, https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1-768x242.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"#sql-nullfunctions-labs\">Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Null Functions  Using <code>COALESCE()<\/code> Example<\/h3>\n\n\n\n<p>This query checks multiple columns in the Doctors table and returns the first non-null value.<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:false,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;default&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SELECT doctor_id, COALESCE(first_name, 'Unknown', last_name) AS name\nFROM Doctors;<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"1024\" height=\"336\" src=\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image2.png\" alt=\"\" class=\"wp-image-1040\" style=\"width:936px;height:auto\" srcset=\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image2.png 1024w, https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image2-300x98.png 300w, https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image2-768x252.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Null Functions MySQL <\/h3>\n\n\n\n<p>MySQL supports functions like <strong>IFNULL()<\/strong> and <strong>COALESCE()<\/strong> to handle nulls. You can use them as follows, In this query, if <code>doctor_specialty<\/code> is null, it will show &#8216;General&#8217; instead.:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:false,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;default&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SELECT IFNULL(doctor_specialty, 'General') AS specialization FROM Doctors;<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Null Functions SQL Server<\/h3>\n\n\n\n<p>In SQL Server, <strong>ISNULL()<\/strong> can be used to replace nulls, <em>This query will replace null values in the <code>last_name<\/code> column with &#8216;Unknown&#8217;.<\/em>:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:false,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;default&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SELECT ISNULL(last_name, 'Unknown') AS last_name FROM Patients;<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Null Functions MS Access<\/h3>\n\n\n\n<p>In MS Access, you can use <strong>Nz()<\/strong>, which is similar to <strong>IFNULL()<\/strong>, This query will replace null <code>last_name<\/code> values with &#8216;Unknown&#8217; in MS Access. :<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:false,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;default&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SELECT Nz(last_name, 'Unknown') AS last_name FROM Patients;<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Null Functions Oracle<\/h3>\n\n\n\n<p>In Oracle, <strong>NVL()<\/strong> is used similarly to <strong>IFNULL(), <\/strong>This Oracle query replaces null values in doctor_specialty with &#8216;General&#8217;.<span style=\"color: var(--ast-global-color-3); font-size: revert; background-color: var(--ast-global-color-5);\">:<\/span><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:false,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;default&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SELECT NVL(doctor_specialty, 'General') AS specialization FROM Doctors;<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"sql-nullfunctions-labs\">SQL Null Functions Labs<\/h2>\n\n\n\n<iframe src=\"https:\/\/www.techkubo.com\/sql-sim.html\" title=\"Try SQL on TechKubo\" width=\"100%\" height=\"500\"><\/iframe>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In SQL, NULL represents missing or unknown data. When dealing with NULL values, it is often important to replace them [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-268","post","type-post","status-publish","format-standard","hentry","category-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Null Functions - SQL Tutorial<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/techkubo.com\/sql\/sql-null-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Null Functions - SQL Tutorial\" \/>\n<meta property=\"og:description\" content=\"In SQL, NULL represents missing or unknown data. When dealing with NULL values, it is often important to replace them [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/techkubo.com\/sql\/sql-null-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Tutorial\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-23T02:25:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-16T06:24:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"322\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Manong\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Manong\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/techkubo.com\/sql\/sql-null-functions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/techkubo.com\/sql\/sql-null-functions\/\"},\"author\":{\"name\":\"Manong\",\"@id\":\"https:\/\/techkubo.com\/sql\/#\/schema\/person\/b4fa2f01fa4ff2a4e98276ce47115965\"},\"headline\":\"SQL Null Functions\",\"datePublished\":\"2024-08-23T02:25:45+00:00\",\"dateModified\":\"2025-05-16T06:24:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/techkubo.com\/sql\/sql-null-functions\/\"},\"wordCount\":256,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/techkubo.com\/sql\/#organization\"},\"image\":{\"@id\":\"https:\/\/techkubo.com\/sql\/sql-null-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/techkubo.com\/sql\/sql-null-functions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/techkubo.com\/sql\/sql-null-functions\/\",\"url\":\"https:\/\/techkubo.com\/sql\/sql-null-functions\/\",\"name\":\"SQL Null Functions - SQL Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/techkubo.com\/sql\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/techkubo.com\/sql\/sql-null-functions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/techkubo.com\/sql\/sql-null-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png\",\"datePublished\":\"2024-08-23T02:25:45+00:00\",\"dateModified\":\"2025-05-16T06:24:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/techkubo.com\/sql\/sql-null-functions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/techkubo.com\/sql\/sql-null-functions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/techkubo.com\/sql\/sql-null-functions\/#primaryimage\",\"url\":\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png\",\"contentUrl\":\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png\",\"width\":1024,\"height\":322},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/techkubo.com\/sql\/sql-null-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/techkubo.com\/sql\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Null Functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/techkubo.com\/sql\/#website\",\"url\":\"https:\/\/techkubo.com\/sql\/\",\"name\":\"SQL Tutorial\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/techkubo.com\/sql\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/techkubo.com\/sql\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/techkubo.com\/sql\/#organization\",\"name\":\"SQL Tutorial\",\"url\":\"https:\/\/techkubo.com\/sql\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/techkubo.com\/sql\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2025\/01\/cropped-Techkubo-logo-1.png\",\"contentUrl\":\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2025\/01\/cropped-Techkubo-logo-1.png\",\"width\":1618,\"height\":1174,\"caption\":\"SQL Tutorial\"},\"image\":{\"@id\":\"https:\/\/techkubo.com\/sql\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/techkubo.com\/sql\/#\/schema\/person\/b4fa2f01fa4ff2a4e98276ce47115965\",\"name\":\"Manong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/techkubo.com\/sql\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21a7455736c21887b8fefe0935012d65?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21a7455736c21887b8fefe0935012d65?s=96&d=mm&r=g\",\"caption\":\"Manong\"},\"sameAs\":[\"https:\/\/techkubo.com\"],\"url\":\"https:\/\/techkubo.com\/sql\/author\/manong\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Null Functions - SQL Tutorial","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/techkubo.com\/sql\/sql-null-functions\/","og_locale":"en_US","og_type":"article","og_title":"SQL Null Functions - SQL Tutorial","og_description":"In SQL, NULL represents missing or unknown data. When dealing with NULL values, it is often important to replace them [&hellip;]","og_url":"https:\/\/techkubo.com\/sql\/sql-null-functions\/","og_site_name":"SQL Tutorial","article_published_time":"2024-08-23T02:25:45+00:00","article_modified_time":"2025-05-16T06:24:40+00:00","og_image":[{"width":1024,"height":322,"url":"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png","type":"image\/png"}],"author":"Manong","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Manong","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/techkubo.com\/sql\/sql-null-functions\/#article","isPartOf":{"@id":"https:\/\/techkubo.com\/sql\/sql-null-functions\/"},"author":{"name":"Manong","@id":"https:\/\/techkubo.com\/sql\/#\/schema\/person\/b4fa2f01fa4ff2a4e98276ce47115965"},"headline":"SQL Null Functions","datePublished":"2024-08-23T02:25:45+00:00","dateModified":"2025-05-16T06:24:40+00:00","mainEntityOfPage":{"@id":"https:\/\/techkubo.com\/sql\/sql-null-functions\/"},"wordCount":256,"commentCount":0,"publisher":{"@id":"https:\/\/techkubo.com\/sql\/#organization"},"image":{"@id":"https:\/\/techkubo.com\/sql\/sql-null-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png","articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/techkubo.com\/sql\/sql-null-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/techkubo.com\/sql\/sql-null-functions\/","url":"https:\/\/techkubo.com\/sql\/sql-null-functions\/","name":"SQL Null Functions - SQL Tutorial","isPartOf":{"@id":"https:\/\/techkubo.com\/sql\/#website"},"primaryImageOfPage":{"@id":"https:\/\/techkubo.com\/sql\/sql-null-functions\/#primaryimage"},"image":{"@id":"https:\/\/techkubo.com\/sql\/sql-null-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png","datePublished":"2024-08-23T02:25:45+00:00","dateModified":"2025-05-16T06:24:40+00:00","breadcrumb":{"@id":"https:\/\/techkubo.com\/sql\/sql-null-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/techkubo.com\/sql\/sql-null-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/techkubo.com\/sql\/sql-null-functions\/#primaryimage","url":"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png","contentUrl":"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2024\/08\/SQL-NullFunctions-Image1.png","width":1024,"height":322},{"@type":"BreadcrumbList","@id":"https:\/\/techkubo.com\/sql\/sql-null-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/techkubo.com\/sql\/"},{"@type":"ListItem","position":2,"name":"SQL Null Functions"}]},{"@type":"WebSite","@id":"https:\/\/techkubo.com\/sql\/#website","url":"https:\/\/techkubo.com\/sql\/","name":"SQL Tutorial","description":"","publisher":{"@id":"https:\/\/techkubo.com\/sql\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/techkubo.com\/sql\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/techkubo.com\/sql\/#organization","name":"SQL Tutorial","url":"https:\/\/techkubo.com\/sql\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/techkubo.com\/sql\/#\/schema\/logo\/image\/","url":"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2025\/01\/cropped-Techkubo-logo-1.png","contentUrl":"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2025\/01\/cropped-Techkubo-logo-1.png","width":1618,"height":1174,"caption":"SQL Tutorial"},"image":{"@id":"https:\/\/techkubo.com\/sql\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/techkubo.com\/sql\/#\/schema\/person\/b4fa2f01fa4ff2a4e98276ce47115965","name":"Manong","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/techkubo.com\/sql\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21a7455736c21887b8fefe0935012d65?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21a7455736c21887b8fefe0935012d65?s=96&d=mm&r=g","caption":"Manong"},"sameAs":["https:\/\/techkubo.com"],"url":"https:\/\/techkubo.com\/sql\/author\/manong\/"}]}},"_links":{"self":[{"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/posts\/268"}],"collection":[{"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/comments?post=268"}],"version-history":[{"count":4,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/posts\/268\/revisions"}],"predecessor-version":[{"id":1218,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/posts\/268\/revisions\/1218"}],"wp:attachment":[{"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/media?parent=268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/categories?post=268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/tags?post=268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}