How to avoid a column if it contains null without mentioning its name

Question

select * from
   ExmGp a
        inner join
    ExmMstr b
        on a.ETID = b.EID
        inner join 
    ExmMrkntry c
        on b.AcYear = c.Acyear

I am trying to join three different tables like the above code but in result some of the columns are null. is it possible to avoid them using where condition?

thanks in advance

you need to do your own function to do that, otherwise, TSQL doesn't have that kind of built-in function. https://dba.stackexchange.com/questions/14864/test-if-any-fields-are-null — iSR5, Apr 07 '18 at 14:11

score 1 · Answer 1 · answered Apr 07 '18 at 10:58

1

No there is no built-in language construct in TSQL to directly check for NULLs anywhere in the row. There are a number of workarounds though.

See this question for possible solutions How to count in SQL all fields with null values in one record?

answered Apr 07 '18 at 10:58

RnP

390
1
8

score 1 · Accepted Answer · answered Apr 07 '18 at 11:09

No, but it is important that you understand the reason why.

The WHERE clause filters rows out of the result set not columns. So, what you are asking is not supported by WHERE or anything else.

Importantly, a SQL query returns data in a tabular format. This format specifies the columns in the result set. These columns cannot be dynamic; they are fixed for the query (unless you construct a string to execute the query).

So, you are "stuck" with all the columns specified in the SELECT. I would recommend that you list each of the columns that you want rather than using SELECT *.

How to avoid a column if it contains null without mentioning its name

2 Answers2