I am trying to wirte a CASE statement based on values from multiple columns. I am having trouble getting it to work properly. Does anyone have any ideas. The CASE Statement below should explain what I am trying to accomplish.
Your example looks like it would fail for having no comma after colB.
Here is a sample of using a case statement based on multiple columns:
and the results are:
answered Jul 12 '12 at 12:00 AM