I cannot get a right syntax for a simple case statement.
I am trying:
Select CASE myfield
when ('val1' or 'val2' or 'val3') THEN 'A'
when ('val4' or 'val5') THEN 'B'
I am getting a syntax error
I also tried to replaced OR with , but no success.
Could you help with the syntax when the case statement has more than one value ?