I have got a table with 50 cloumns
I wish to select for a single orw only those columns
which are having not nul value
For example
Table1 ( ID Int (PK),Col1 Char,Col2 Char,Col3 Char)
The values are
ID Col1 Col2 Col3
1 A B Null
2 C Null Null
I want to select fOR id = 1 Only those columns which are not null i.e Col1 , Col2
OR
For Id =2 just Col1
The problem is ihave got 50 columns and i have no way of no knowing which of these columns is not null