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.
(comments are locked)
|
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:
(comments are locked)
|