I have a table with almost 100 columns and an assortment of fields that are null for some records. I'd like to be able to select all the records based on a criteria value and have it return the columns/fields that are not null across all the matching records. This way I can populate a table with all the relevant fields for the matching records but not have fields where every record is null. Does that make sense and if so is it possible? I'd really like to avoid having to avoid doing this for every specific column where as I said there are almost 100
Thanks