Nah... you didn't mislead. I forgot to include the column name being checked by the case statement. You picked up on that correct, it would appear.
For your output, just alias the CASE statement with columnname = CASE .... and you should be all set.
--Jeff Moden
Change is inevitable... Change for the better is not.