Finding Not Null values in a table

Hi-

Can anyone suggest a convenient way to select from a large table only those fields whose values are not null for a particular row? I have a large table that I am trying to pull only the 'not null' fields for a particular key record. I am wondering if there is some way to 'select all not null values from big table where primary key = something' (I guess this is essentially select * but don't show me any fields whose value are null). Any ideas? Thanks a lot...

Nathaniel

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 28 1998 - 09:54:20 CST