0 votes


   A= 'B' or 'C' or 'D' then  'E'

   A = 'F' or 'G' ..... or 'Z' then  'F'

   A = 'G' then  ‘H'

else 'NA' end as test

You can use both IF or Case when statement, but provide me with the best solution. Thank you!
closed as a duplicate of: Case when with multiple cases like
asked by anonymous
closed by

1 Answer

0 votes
answered by
741 questions
762 answers
483 users