You can't do that easily.  You'd need one query to determine which columns contain values, and a second query to select only those columns.  Maybe some sort of dynamic pivot would work, but I haven't really thought that through (it would be cumbersome).  Or you could just return everything and have your presentation layer choose which ones to display.

John