Re: Interesting query outcomes

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

> "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...

You might also try using IF(expr1,expr2,expr3) to see if it changes your 
results.