>Hi Guys,
>
>I have a table that has around 100 columns. For each record, not all columns have values.
>
>Example :
>Row1 = Pkeyno, Column1, Column5, Column10, Column 15.... have values
>Row2 = Pkeyno, Column2, Column4, Column13, Column 114.... have values
>
>Is it possible to do a Select statement using the pkeyno as the where clause that would return all columns with values only?
>
>Thanks in advance....

Please provide some sample data like the current file and some sample data for the result you want to see.