Okay it is not Dr. Jekyll and Mr. Hyde but I had to come up with a title. This was a question someone asked yesterday in the sql programming group http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/126735827b7ae667# This person had a case statement like this SELECT CASE WHEN COL1 IS NULL THEN 'UNK' ...