At 02:46 PM 8/10/2004 +1000, you wrote:

> > >I'm running a simple group by query that returns the name of the group
> > >and a count. One of the "groups" is a blank. Instead of just having a
> > >blank, I want to say "No Value Specified".
>
> >
> > If your "blank" is really a null, then you can use coalesce instead.
> >
> > ./h

Alan McDonald commented:

>and there could be NULLS *and* blanks.

Hmm, he said "one of the groups". Can you describe how that group could be
both NULL and blank?

Helen