Re: display only populated fields

2004-09-29 Thread Rhino
- Original Message - From: "Tracy Gems" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 28, 2004 5:59 PM Subject: display only populated fields > > How do I go about only displaying fields that have data and are not empty or have NULL?

Re: display only populated fields

2004-09-29 Thread SGreen
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

display only populated fields

2004-09-29 Thread Tracy Gems
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