You 'can' do this, but it's a VERY inefficient query. I would suggest looking at a db redesign or managing the return set for null columns.
Basically, you have to use pivot to turn columns into rows, select IS NOT NULL and then unpivot them back again.
Like I said, this is not at all efficient. The feature is only in T SQL by request, not design.
Not only is it not ideal for that reason, it's also a bugger to get your head around. Here is a link to help you get started:
https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx[
^]
I
strongly suggest you don't use this technique and find a different solution to your problem as has been suggested in other solutions. By following this route you agree to not find me responsible for any migraines or brain aneurysm that may result
Good luck ^_^