remove null column in SQL

Is it possible removed any columns that is null?
sample select *from table1
VBdotnet2005Asked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
If you are unable to solve this in the front-end (though why you would even consider doing this is beyond me) and are adamant to do it with T-SQL alone then consider something like this:
IF EXISTS (
	SELECT 1
	FROM dbo.YourTable
	WHERE YourColumn IS NOT NULL)
	SELECT Col1, Col2, YourColumn 
	FROM dbo.YourTable
ELSE
	SELECT Col1, Col2 
	FROM dbo.YourTable

Open in new window

0
 
sunezapaCommented:
remove rows by Select * from table1 where column is not null
and
show nulls as something else by Select ISNULL(column,'') from...

but what do you exactly means with "Remove Columns"?
0
 
VBdotnet2005Author Commented:
let's say it a result has any column that is null, I want to be able to remove it from the result
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
VBdotnet2005Author Commented:
select field1, field2, field3 from tabl1

result

john      doe      null
jim      doe      null
james      doe      null
            

I dont want to get null column

Just this

john      doe       
jim      doe       
james      doe       

0
 
Anthony PerkinsCommented:
SELECT *
FROM YourTableNameGoesHere
WHERE YourColumnNameGoesHere IS NOT NULL
0
 
Anthony PerkinsCommented:
Ah, that is different.  You will have to handle that in your front-end.
0
 
sunezapaCommented:
try the ISNULL thing...
Select  field1, field2, ISNULL(field3,'') from table1

Open in new window

it will not return any NULL values (in example an empty string is returned instead)...
0
 
SharathData EngineerCommented:
If your result is

john      doe      null
jim      doe      null
james      doe      abc

What would be your expected result?
           
0
 
VBdotnet2005Author Commented:
Above three columns
If the entire column are null,I want to remove it
If partials, leave it alone
0
 
sunezapaCommented:
no SQL code can know what "the next records" will be, so it is not possible to decide to bring a column or not at runtime.
Do the "filtering" in your frontend.
Maybe ask more detailed what the purpose is - there may be easy solutions, other than what you describe...
0
 
SharathData EngineerCommented:
What is your SQL Server version?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.