Db2 where is not null

The ISNULL function will go for searching the first non-NULL value; if the column has any date stored in it, then it displays that date else, it goes further to replace that null value stored in the column with the value specified in the second parameter.

The output of the above query statement is shown below with replacing the values of the purchase date column with null values with the date that we have specified in the last value retrieved in the select query.

We can also make the use of the ISNULL function to replace the column value having NULL in it with some other column value by specifying the column containing NULL values as the first argument and the column with which the value needs to be replaced in the second argument.

Consider an example where we have the table named workers created by using the following query statement. Using the following query statement, we can display the column address2 value in address1 place if it is NULL, as shown below. You may also have a look at the following articles to learn more —.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.

Asked 6 years, 10 months ago. Active 6 years, 10 months ago. Viewed 31k times. Good day, I have a row of data with a column, call status, the value inside is null. Kindly advise. Improve this question. Rory McCrossan k 37 37 gold badges silver badges bronze badges. Panadol Chong Panadol Chong 1, 9 9 gold badges 42 42 silver badges 86 86 bronze badges.

Improve this answer. Lennart Lennart I'm not a DB2 expert, so this may or may not be applicable to your system. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta.