how to select only fields with ‘not null’ values

Question

Hi, i need to select only fields with values. but my code doesn´t work, WHY?

Suraj Kumar · Answer

If you want to select rows which has not null values and also not the values like blank space then you can use ISNULL in a single query also as shown below. It will check both at the same time. Below is that query. Select , , .... from where ISNULL ( , '' ) '' AND ISNULL ( , '' ) '' You can learn in details about ISNULL from the below given link. https://www.c-sharpcorner.com/blogs/sql-server-isnull-with-multi-column-names

Ramon Quintana · Answer

Hi John, as you see i run this code but it returned fields with values and NULL or BLANKS

Ramon Quintana · Answer

Hi John, as you see i run this code but it returned fields with values and NULL or BLANKS

John Criswell · Answer

Ramon, I cannot tell which of your scripts created the result. You have two scripts with where clauses that limit trans_type to NOT NULL. The other two have no where clauses. Still, there is no way this could be happening. If there are NULL's and NOT NULL values in a column and your where clause has is not null, then only NOT NULL values will be returned. I would try running script #3 again to verify.

how to select only fields with ‘not null’ values

Answers (4)