Hi all,

We're implementing a web-based database application for keeping track of employee emergency information. I need a sql query to select a row, but leave out any fields that are empty (but not null). I've got it working so that all fields in a row are selected. The problem is, I don't know which fields will be empty, so I cannot hard code the select statement to leave out certain fields.
Any help is appreciated.

Thanks.

Apparently this means a problem with the db design.

But you may freely post your table's schema together with some sample data.

krs,
tesu

I guess that I don't understand. If you were to make a temporary table out of the data that you want pulled down, what would it look like?

I've got it working so that all fields in a row are selected. The problem is, I don't know which fields will be empty, so I cannot hard code the select statement to leave out certain fields.

First requirement of its types I have seen, Whats the schema ?

-------------
Shucks dint see the last post was 5 days ago

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.