| Subject | Group By SQL - Give Blank a "Title" |
|---|---|
| Author | ra8009 |
| Post date | 2004-10-08T04:14:03Z |
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".
How can I accomplish this with SQL?
and a count. One of the "groups" is a blank. Instead of just having a
blank, I want to say "No Value Specified".
How can I accomplish this with SQL?