If you are using something to run this query, what is it? What tool(s) are you using to retrieve/view the data?
Shawn Green Database Administrator Unimin Corporation - Spruce Pine Tracy Gems <[EMAIL PROTECTED]> wrote on 09/28/2004 05:59:08 PM: > > How do I go about only displaying fields that have data and are not > empty or have NULL? > > It's a 112 column table so I only want to display the fields that have data. > > Thanks. > > select * from table where ......... > > > --------------------------------- > Do you Yahoo!? > Yahoo! Mail is new and improved - Check it out!