Re: Interesting query outcomes

"Lyle H. Gray" <[email protected]> wrote in
news:[email protected]: 

> Have you tried using either the IFNULL() or COALESCE() functions
> instead of the CASE WHEN block?

Of course, that would only work if chose to convert a NULL to a blank to 
match the other blanks, rather than 'default', so that might not be an 
option for you...